I receive the error or request to link master and child fields when i work on the Apartments table once I have entered an apartment number and click the plus button to expand to the procedures table.
Apologies this was left over from when I've been experimenting with different relationships between tables. I've deleted it now and it has made no difference. To be specific it states Insert Subdatasheet and asks for the link Child and Master fields in dialog box.
Please find attached the relationship report pdf for the database.
The field and table names I used before are slightly different than I described before as I was trying to keep it simple when I was explaining in my first post.
The apartment fields throughout are Text and not Autonumber.
In...
This is correct there can be multiple snags per apartment only.
If I add an "apartment Id" field into the snags table and then create a many to one relationship between this and the apartment Id field in the apartments table I get errors asking to link parent and child fields which I don't...
Good Afternoon,
I am a project manager in construction and I'm currently looking to make my life easier on projects by tracking the progress and issues associated with high rise apartment builds.
I have created a database that does just that and has been working fine until I wanted to add a...