Novice
Windows 7 32bit 
Access 2007
I was creating a form by form wizard that has fields from 3 tables that is located on my back end db. When I finished the process, it informs that I donīt have relationship between the tables and then I was dropped in mey front end relationship tab.
These tables are all related in my back end db, why is that happening?
VIP
Windows 7 64bit Access 2010 32bit
Why are you including 3 tables in form RecordSource? Is this form for data entry/edit?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 7 32bit Access 2007
Yes, it is!
VIP
Windows 7 64bit Access 2010 32bit
A form can enter records for only one table. Possibly you need form/subform arrangement. Depends what the other 2 tables are for. Are they lookup tables or are they related child tables as would be for an Order and OrderDetails?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Front end help
Posting Permissions
Reply With Quote