CHILD TO PARENT TABLE

Question

Hi,How to do lookup a field input in Child table on to the Parent Table?------------------------------Tarvinder Ghatrora------------------------------

tarvinderghatro · Answer

It worked!Thank you, Mark!------------------------------Tarvinder Ghatrora------------------------------

nirajshah4 · Answer

Can you provide more information? You want to bring information from the child table to the parent?

What type of field is the one you wish to bring over from Child to Parent?

------------------------------
Niraj Shah
------------------------------

tarvinderghatro · Answer

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
------------------------------

markshnier__you · Answer

Which Child Record's data do you want?&nbsp; What if there are multiple children?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

tarvinderghatro · Answer

Hi Mark:I have below three tables:Purchase OrderBookingBooking POFirst Purchase Orders are entered in Purchase order table2nd a booking is created with multiple Purchase orderMultiple Purchase order against booking are entered in Booking PO tableThere 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------------------------------

Forum Discussion

CHILD TO PARENT TABLE

10 Replies

Related Content

Parent to Child Reference Field

Lookup & add multiple records from a child table and add them to a parent table record

Totaling Child Records Live on Parent Using New Form and New Grid Reports Locking Parent Record

Totaling Child Records Live on Parent Form

Add child record through parent form and redirect back to parent form in edit mode