Don't use your 17 digit number to link one table to others. While this can be done, it's not a good idea. Instead, enter the chassis number in a normal data field and then refer back to this parent record whenever you need the chassis number. That way, should the number ever be entered in error in the parent record, you can correct the mistake without losing the link to your related records in other tables.
This can give you a relationship like this:
Chassis::ChassisID = ChildTable::ChassisID
Where ChassisID is an auto-entered serial number field in Chassis and a number field in each related ChildTable.
ChassisNumber is then a text or number field you define in Chassis. If you are on the layout of a related ChildTable, you can add the Chassis::ChassisNumber field directly to this layout and it will display the corrent value from the related parent (Chassis) record.
Oké, thank you.
So with chassisId you just mean the name of the trailer and not the 17digit number?
So I just link the name from Chassis::ChassisID = ChildTable::ChassisIDfk and you think the records wil become visible then?
I am sorry for the questions but I am stil learning. I was also thinking of making a script that just copy's and paste's the chassis number where it is
needed, but I don't know if this is a good idea.
Thank you for the fast reply
No, ChassisID would be an auto-entered serial number field. This is a file option setting you define on a number field in Manage | Database | Fields.
Oké, so you mean this is just an ordenary auto entered serial number field with no special numbers,
this is just a number to seporate the records from eachoter by numbers then?
Thank you for your help.
That's it exactly. You can still have fields for your other ID numbers, just don't use them as key fields in your relationships and your database will be easier to manage.
Oke thank you,
I did this now. I named them "controletabelID" and the childtable I named "controletabelIDfk" and related these together.
But when I put the chassisnumer field on te related records. they stil do not show. (only in the parent table it does, but not in the childtables)
I keep having a blank field with no value inthere. I have made a new field and set it to related records (chassisnumber)
I have to say the chassinumber field is also an auto enter value that per record that I create, goes +1, does this have anything to do with it?
You'll need to take a look at your relationship between your tables and the values in the key fields used in that relationship.
If you have this relationship in Manage | Database | Relationships:
ControlTable::ControlTableID = ChildTable::ControlTableIDfk
Then you can add ControlTable::ChassisNumber to a layout to ChildTable. If the ChildTable::ControlTableIDfk = 1, then the ChassisNumber from the record in ControlTable where ControlTableID = 1 will appear on your layout.
I did everything that you sayed and checked 2 times. Still I do not have any value in them. :S
I tryed the same thing with the tables of the Lynda databases I got and that does work with them.
So I think there will be something wrong with my table then. Perhaps it is best to start over.