Relating a record... ...probably simple, but i'm a retard

[mattballoon]

Hi. I am probably really stupid... But... How do you get a field to repeat itself in another table. This is because i want to spread my data over 2 tables. Every time i try, i always end up with no records being visible, and the two tables do not update with each other. Cheers.

 

[Telsa]

This is best done using SQL. You will need to create a SQL string that will update both tables based on a common field.

Let's say the common field is called PRODNUM. And the two tables are LINKS and FILES.

The form you have is connected to the table FILES. Then to update the LINKS table with same info the FILES table has. For each field you would need to write the SQL string.

The a sample string would read:

UPDATE links SET links.name = "lj212" WHERE links.prodnum = files.prodnum

Now you need to decide when you want this update to happen... during the afterupdate event of the field you changed? after it loses focus? when you click a save button?

HTH

Mary )