Thank you for your post.
How do you know if a calvenumber is assigned to an owner?
In order to see the unassigned calvenumber, you will need to create another relationship between Owner and Calvesnumbers tables. While in Manage Database, click on the Relationships tab, and a graphical representation of your tables are displayed. Click the lower left icon to create another table occurrence of Calvesnumbers. You will then need to set a relationship to view the unassigned calvenumber. Assuming there is a field "Assigned" in Calvesnumbers with the values "Yes" and "No", create a text field in Owners table with global storage and enter "No". You can then use this field to link to "Assigned" in Calvesnumbers. Then, you can display another portal that shows all the unassigned calvesnumbers.
Thanx for the answer!
How do you know if a calvenumber is assigned to an owner?I know that because the Calvesnumber-table has a relation to the Owner-table! .. That would assign the calvenumber to the owner, would it not?!My real deal here is to assign Fencenr. 1 ... 2 ... 3 .. and so on, to the owner and his calvenumbers.It would look like this: - In Fencenr.1 the owner Stig has calvenumbers 12, 45, 98 and so on. These calvenumbers must be unique for Fencenr.1 and belong to one owner only! But in Fencenr.2 Stig could have the exact same calvenumbers as in Fencenr.1...Hopefully you understand!You have any solution for this, please?