LjushaMisha
Registered User.
- Local time
- Today, 23:28
- Joined
- Mar 10, 2017
- Messages
- 81
Dear LarryE,Here is an explanation of what the OP is attempting to do with ACCESS. It appears they are trying to track garment parts to be used to make garments, although I do not speak the language used in construction the tables and fields:
View attachment 120579
The OP has no relationships in the database between the two tables, so basically, they have two tables they are using like spreadsheets. The OP believes that some code they got off the internet will somehow make this work. It will not.
@LjushaMisha:
Given the description in the Readme table, you need to construct this project as a relational database which is what ACCESS was designed to be, based upon the requirements outlined in your Readme table included in the project. No code will help you do this.
I have tried to make relations, but the only way was to make table for each LEVEL but I didn't find it "user friendly". That's why I have in "tblSestav" two fields (Ses_Nivo and Ses_Nadrejen_Id) - they actually work as connection between two tables. "Ses_Nivo" could be also called LEVEL and "Ses_Nadrejen_Id" could be called SUPERIOR PRODUCT ID.
From attached file to June7, you can see IT WORKS also in that way. Although it is maybe wrong from Access master view.