DONGNGUYEN
3 years agoQrew Trainee
Any idea?
Hi, I am trying make a Cargo Management System for my company. Now, I have 3 table, they are (1) Sender (Name, phone#, and address), (2) Receiver ( Name, Phone #, Address), and (3) package ( It (1)+(...
Yes, the Tracking number would trigger a pipeline, then it will fill the full table of pallet that have Tracking number - name- weight,... and so on. So when I do grid edit, I put in tracking number, then It will fill out for me the rest, instead of me put it in manually. However, I want the pallet will connect to each package, so that I know which package in which pallet, and which pallet that have how many package. Is there is anyway to do it?
------------------------------
DONG NGUYEN
------------------------------
If I am listening correctly I do not think you need a Pipeline. You can build this instead:
Every Pallet will have many Packages.
Set the Tracking Number as the Proxy field for the Related Package when you make the relationship.
Here is a picture of a Parent Child Relationship and the Proxy Field
When you Grid Edit the Pallet List Table, you will select the Package Tracking Number. That will create the relationship and then all the Look Up fields from the Packages will be usable there.
The one thing to make sure of is that the Package Tracking Number is unique in the Package Table.