Automatically populate information

[Blindability]

Hi all

This is possibly a really easy nubie question, so I hope the answer is very simple!

Is there a simple way of auto populating information between tables? Essentially I have a list of people who are registered on a table. I want to be able to type some information into another table, and all of the relevant details are auto populated.

Can anybody help with a simple step by step for this, or is it complicated?

Thanks in advance

[NoellaG]

Hi,

it is quite simple if you have a good database design. You create a table with the main information, for example Customers (name, address, ...) and each customer has an unique number (primary key field). Than you can have a second table with, for example orders, and all you have to to is to repeat the customer number in thet table to be able to retrieve all corresponding data from the customers table. Just take some time to get familiar with relational database design.

succes
NG

[Blindability]

Hi,

it is quite simple if you have a good database design. You create a table with the main information, for example Customers (name, address, ...) and each customer has an unique number (primary key field). Than you can have a second table with, for example orders, and all you have to to is to repeat the customer number in thet table to be able to retrieve all corresponding data from the customers table. Just take some time to get familiar with relational database design.

succes
NG

Thanks, so if I were to have the table as suggested and have the URN as the primary key, create a second table where I want to populate the information. Create a relationship between the two tables and then once the URN is entered into the new table, everything else should populate. Is this correct?

[Bob Fitz]

Thanks, so if I were to have the table as suggested and have the URN as the primary key, create a second table where I want to populate the information. Create a relationship between the two tables and then once the URN is entered into the new table, everything else should populate. Is this correct?

I think you would benefit from reading the following link: https://www.accessforums.net/tutoria...ase-45451.html

[June7]

'All of the relevant details' should NOT be populated into the second table - only the record ID should be. Duplicating data between tables violates basic relational database principle. Only save the PK/FK value so tables can be linked in queries to make related info available.

There are techniques to display the related info on form but this is not to save the data into record.

Should not be working directly with tables. Use forms and reports for user interface.