drop down lists + which also selects corresponding fields.

[rvd48]

i am building a computer database for my A'level ICT coursework.

basically, the end user enters the customer's details in with the components and prices to store as a record.


i have designed a table called 'CustomersTbl' which has the fields: CustomerID, First Name, Last Name, Gender, Address, Post Code and Tel no.

now, i have lots of other tables listing all the computer components with their prices such as floppy drives, graphics cards,etc

i am in the process of making a table called 'DeliveryTbl' which contains all the fields in CustomersTbl and some fields from each of the component tables, from doing lookup's in design view.
the thing i want to do is: when i select a CustomerID in this new table, and the drop down box appears, i want to click on one and all the corresponding data to appear in the other fields such as First Name, Last Name, Gender,etc without me having to manually select each field, how can i do this?

(then i can select what components i want each customer to have).

Thankyou.

 

[ColinEssex]

i have designed a table called 'CustomersTbl' which has the fields: CustomerID, First Name, Last Name, Gender, Address, Post Code and Tel no.

now, i have lots of other tables listing all the computer components with their prices such as floppy drives, graphics cards,etc

i am in the process of making a table called 'DeliveryTbl' which contains all the fields in CustomersTbl and some fields from each of the component tables,

why are you repeating the fields from 'CustomerTbl' into the'DeliveryTbl'?

and

what are the "lots of other tables"? could it be a table for each component?

Col

 

[Mile-O]

now, i have lots of other tables listing all the computer components with their prices such as floppy drives, graphics cards,etc

You should only need two tables to store this.

 

[Mile-O]

You might appreciate (or better understand) why two fields from looking at my attachment - and argument - on this thread.

 

[rvd48]

so, i should import all the different component data to one table and have anotehr table which has the customers address details?