Please show a screenshot of Base → Tools → Relationships. Don’t know why you won’t create the relations in this tool.
1 Like
Sorry R, but it won’t let me upload, paste the screenshot. Too big.
Can this really be that hard?
I’m I the first to want a employee to enter there name in a workorder form and it be checked that it is also in the employee name table?
Examples are great at joining int to int columns, which I’ve done, but I don’t need that number, I need their name.
Maybe if the user could enter their employee number and it would automatically fill the adjacent name column/Object would the join number have value.
Tu
So you had created the realtionships. If you don’t want to fill all this by the Integer for the foreign key you need a form. In a form a foreignkey should be filled by a listbox. A listbox will show the names and insert the foreign key in the datasource. Please have a look at the Base Guide for this.
1 Like
Hi R,
But what is the reason for the foreign key?
Couldn’t I have made a list box with macro, that would’ve restricted the user to my employee names table, bypassing all the trouble of learning foreign key constraints?
Without defining such a key you could delete all the names after you have inserted the key-values in the employee-table. Your data will be corrupted, because there are numbers in your table but names for this numbers won’t exist.
1 Like