Layout mode Tabs & Fields. Arrgghh!!!!
I've set up a four table database with some basic relationships. As a result, a layout has been created based on each table. When I select "New Records" in each of these layouts I can enter data into the relevant fields.
Instead of switching between layouts when entering a new record, I have created 3 separate tabs in the main layout. Each tab contains fields from each relevant table. When I select "New Record" I can enter data in the fields that arent contained in any of the tabs. But the fields in the tabs themselves will not allow me to enter data or even click a cursor onto them!
Could someone please advise?
Many thanks in advance