TimjHebert
Registered User.
- Local time
- Today, 17:01
- Joined
- Dec 12, 2004
- Messages
- 40
i have a db with several tables.
tblcustomer CustomerID=PK
tblshorebase ShorebaseID=PK and CustomerID as FK
tblportable ShorebaseID=FK
i built a form using the tblcustomer. i then built a tab form using tblshorebase and saved it. i then opened the customer form and inserted the tblshorebase form in it as a subform. when i open my tblshorebase form i can see that the FK (CustomerID) is not being updated. what could be wrong?
Thanks in advance!
Tim
tblcustomer CustomerID=PK
tblshorebase ShorebaseID=PK and CustomerID as FK
tblportable ShorebaseID=FK
i built a form using the tblcustomer. i then built a tab form using tblshorebase and saved it. i then opened the customer form and inserted the tblshorebase form in it as a subform. when i open my tblshorebase form i can see that the FK (CustomerID) is not being updated. what could be wrong?
Thanks in advance!
Tim