Realtions

Hey guys i have a litle application im doing for client billing.

i have a table for members ,services and billing.

now in my billing table i have client id service price and date

now in my form to insert the info i tryed to do a list box to select a client.i got that part and services list box to

now my first question is how can i insert the list box field in my billing table?

list box clients to client id

list box services to service

...

and in my services table i have a colum service and a colum price.

can i make a list box the shows the service and there is a filed attached to it that shows the price?

so i can insert the service in on colum and price in the other..

im i making any sence?lol

thx

Just like text boxes, list and combo boxes have a 'ControlSource' property. Specify the field from table to save data. List and combo boxes also have a 'BoundColumn' property which specifies which column of the box has the value to save when item from list is selected.

Use the list and combo boxes RowSource property to query the Services table for the fields you want to display in the list.

i will try it out.thx!