Relating Tables

chris11590

Registered User.
Local time
Today, 08:24
Joined
Jul 29, 2008
Messages
130
I have the following tables setup:

IncidentTble
ScopeTble

to relate both tables:

ScopeTble/fields=
Scope Id= PK= autonumber
Scope=memo
IncidentID=number

the problem i encounter is:

when I enter a scope, the IncidentID should show a number which is related to it. However, the IncidnetID remains at zero.

do i have to go a step further and create a query to update the scopetble? How do i get the info updated?
 
What relationship do Incidents relate to Scope? 1:1; 1:m? Are you using a form and SubForm?
 

Users who are viewing this thread

Back
Top Bottom