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?
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?