Anthony.DG
Registered User.
- Local time
- Yesterday, 17:58
- Joined
- Oct 18, 2019
- Messages
- 27
Let me setup my issue. I have 3 tables labeled Carrier TruckNumber and Invoice Table TruckNumber has a lookup field Carrier referring to table Carrier field CarrierName.
Now what i want to do is in the 3rd table Invoice I want to create a lookup field TruckNumber to table TruckNumber displaying field TruckNumber in column 1 and field Carrier in column 2. I can do this just fine but the problem is that column 2, referencing lookup field Carrier displays the field CarrierID from table Carrier but i want to see what name the truck number is next to.
We have our own trucks/trucknumbers and we log other carriers trucks/trucknumbers that come and pick up material from our yard. We keep track in case something gets brought up and we can refer to who with what truck took what material. Some companies have the same numbers so we want to keep them separate. I want to make sure that the truck number selected in invoice goes to the correct carrier.
Can it be done or should i rethink my structuring?
Now what i want to do is in the 3rd table Invoice I want to create a lookup field TruckNumber to table TruckNumber displaying field TruckNumber in column 1 and field Carrier in column 2. I can do this just fine but the problem is that column 2, referencing lookup field Carrier displays the field CarrierID from table Carrier but i want to see what name the truck number is next to.
We have our own trucks/trucknumbers and we log other carriers trucks/trucknumbers that come and pick up material from our yard. We keep track in case something gets brought up and we can refer to who with what truck took what material. Some companies have the same numbers so we want to keep them separate. I want to make sure that the truck number selected in invoice goes to the correct carrier.
Can it be done or should i rethink my structuring?