Linked Fields

[dgmorr]

Hey guys,

I have two tables that share a common field. Is there a way to allow Access to update both at the same time? If I change one in Table1 it does not automatically update the same field in Table2. Is this possible?

 

[voidcranium]

You should try to find a way to limit your data to one table.
You could make a lookup field in one table that pulls data from the other table.
That way when you change it it is changing the original table.

[U]First_Table[/U]
name_ID (Primary key)
F_name
L_name

[U]Second_Table[/U]
address_ID (Primary Key)
L_name (Foreign Key)

This example uses the L_name from the First_Table as a foreign key in the Second_Table.
If you change the data in the Second_Table it will change the data in the First_Table.
Think this is the way you can do it.

 

[dgmorr]

I would keep it in one table, but I want to be able to easily export only the secondary table . I guess I could do a create Table query, but another reason was because I also wanted a form to access the secondary table. I'm not too sure if I'm on the right plane of thought, there may be an easier way to do this.

With the lookup table, I can only do a lookup via a combo box, or list box. How about text fields?

 

[voidcranium]

I read this somewhere and I think it is pretty good advice.
TABLES are for storing information.
If you want to do something with the information then use a query.
I think you need to look into queries.
Run your forms off of queries also.