CHILD TO PARENT TABLE
Hi, How to do lookup a field input in Child table on to the Parent Table? ------------------------------ Tarvinder Ghatrora ------------------------------
Forum Discussion
A Text field - Booking Number.
I have a Booking Table, where a PO number is attached by selecting from PO Table.
The booking number need to be added to PO table against the selected PO number after the record is saved.
------------------------------
Tarvinder Ghatrora
------------------------------
I have a Booking Table, where a PO number is attached by selecting from PO Table.
The booking number need to be added to PO table against the selected PO number after the record is saved.
------------------------------
Tarvinder Ghatrora
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendWhich Child Record's data do you want? What if there are multiple children?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Hi Mark:
I have below three tables:
Purchase Order
Booking
Booking PO
First Purchase Orders are entered in Purchase order table
2nd a booking is created with multiple Purchase order
Multiple Purchase order against booking are entered in Booking PO table
There are one field (Cargo Ready Date) entered in booking which is moved to Booking PO table through lookup against particular PO and Booking Number.
Now, here is what a problem now is from Booking PO table i have to move Cargo Ready Date and Booking number to Purchase Order Table.
I hope i was able to explain.
------------------------------
Tarvinder Ghatrora
------------------------------- MarkShnier__YouIs this a many to many relationship?
Purchase Order < Booking PO > Bookings
ie One Purchase Order has many Booking POs and also One Booking has many Booking POs.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- It is One Purchase Order has One booking and One booking may have many POs (Purchase Orders)
Therefore, the Booking number need to be moved to each Purchased Orders
------------------------------
Tarvinder Ghatrora
------------------------------