Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Form Question
Hello All Users

I am trying to create a Two forms on the same page and a details view

Consider this for a warehouse distrubition system

1 Shipment contains many boxes
1 Box contain many innerboxes
1 inner box contain many products (details)

Only the details (products within the innerbox) should be displayed in a grid (Table view) All the other parts i would like in a form view.

I know how to create a parent and child linked fields and this works fine, but i can't create grandparent-parent-child-doll ! if you get my drift.

so if the record of the grandparent record is changed, the corresponding records would change too.

If anyone has done this before please share! I have posted question to TD, waiting for their reply too.

Richi
ID
799
Category
Customization
Author

rishi uttam
Date Created
11/14/2014 3:59:57 AM
Date Updated
2/5/2020 12:33:57 PM
Comments
Philipp Matuschka (MMB) 11/15/2014 3:21:51 AM
Richi

Is your question about getting the relationships right in the DB or about presenting all of that in a Form?
rishi uttam 11/26/2014 6:50:00 PM
Presenting on a form, i am not sure how to do this.. TD support informs me that i cannot put subforms in a form.. thats how access does it.

im having difficulty structuring the above layout...
Philipp Matuschka (MMB) 11/27/2014 6:08:18 AM
Sorry, I can't help with that one.
Rebecca Sell 2/2/2020 2:31:18 AM
Hi, did you find a solution? I’d be interest to know if you did?
Currently I can only view child records from the table link at the bottom of the record or as a concatenation which of course has no functionality

Kind regards
Rebecca
daniel.luz@morigd.com 2/5/2020 12:33:57 PM
Hi there,

I would create a many to may relationship between the parent and the grandparent table, and show the report of the corresponding records on the parent register.

To make it work, yo may have to send the Parent record ID to the child (as a lookup field) and again to the grandchild, also as a lookup. Them you can use this ID field as a match collum in the many to may relationship between theses two tables.

Regards,

Daniel Luz
Feedback
Back to Search Results