create a table that fills in other fields automatically

[scottappleford]

Hi

I would like to create a db that assists me when I type. I would like to select from a drop down box the make of a laptop then once selected it fills out the other fields for me i.e the model and whether it is suitable.

The makes used are all the same model so the is fine.

Thanks in advance

scott

 

[FoFa]

Really, if I understand it sounds like you want a FORM that once the computer is selected, it populates that information from the other table. Typically you would have a key on your COMPUTER table (autonumber, model number, something such as that) and you would store that key in your other table/s so you can reference the computer table by that key rather than store all the computer information multiple times.

 

[hi there]

if i'm understanding correctly it sounds like you might want a form based on an AutoLookup Query, which is similar to what FoFa was describing. this is a one-to-many relationship. you can make the relationship at the table level using a lookup field (one side to the many side) or create it on the fly from a query. i recommend doing this with a query. you must create the join in the query based on the common field from the many side of the relationship.

ex.

A. create a new query based on both tables: ComputerSpecs
and the other table
B. include the primary key from the "other table" and other
required fields (one side).
C. include the other fields you want from the ComputerSpecs
table along with the common field (many side).
D. create a form based on this query.

now when you select the common field (many side) it will fill in the corresponding values from the ComputerSpecs table.

hope that helps.