RelatingTbls

[Chris]

i have the following tables setup:
IncidentTble
ScopeTble

To relate IncTables with ScopeTble I have the following field set up:

ScopeID=pk=autonumber
IncidentID=fk=number
Scope=memo


when i enter data into the incident table the scope table is not being
update. do i need to go a step further by creating a query. I have a
relationship between scopetble and IncTble.

 

[Wayne-I-M]

Hi Chris

Access does not work like that.

Don't work (add data) to the table.
Create 2 forms based on IncidentTble and ScopeTble

Open the form based IncidentTble in design view
View the tool box
Select the SubForm icon
Add the form based on ScopeTble
Link the forms on linking field (which should be on bother forms)

good luck