Autofill Question

[the606]

Hi,

 

Im stuck with something really simple, please can you give me some assistance as I'm having a brain block.

 

I have two tables,

 

Lets say they are called cars and customers.

 

In the car table it will contain the following.

 

Registration number

Model

Engine size

no of seats.

 

In the customer table it contains information about the customer but also the info about the car that they own (using same field names as above). I want to be able to type in the registration number in the customer layout and for it to look this up in the cars table and 'autofill' the fields (model,engine size and no of seats) in the customer table based on what it reads from the car table.

 

hope this makes sense, I know its simple but im stuck...
 

Any pointers would be appreciated.

[LaRetta]

Hi!  Welcome to FMForums!

 

The whole purpose of relational databases is so that you do not need to duplicate information in two places.  Not only does proper relational eliminate redundancy but when you have duplicate information in two places, you risk that you will change the data in one place and not the other.

 

Here is a sample of how you should be structured.  And this allows a Customer to have more than one car.

The606.fp7.zip

[the606]

That's great, thanks for spending the time to do this. Ill have a play and come back. Much appreciated.