Pull particular fields from table on form

Question

I have a form that has a child table embedded in it. When a user completes the form they may select multiple things in it. One of the fields they fill out in the table is "quantity". Once they save the form is there a way to pull out just that piece of data and put it on an EFP document? As of now I am having to move the entire table over and it is messing up my forms format and I am unable control certain aspects of it. Since it doesnt have a field ID number but rather is the table- I dont know of a way to control just certain fields within an embedded table.

------------------------------
Mike Klausing
------------------------------

markshnier__you · Answer

Are you talking about the Exact Forms Plus add on? "EFP"?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

mikeklausing · Answer

That's what I need to end up using that field on yes.

Thank you,
Mike Klausing

------Original Message------

Are you talking about the Exact Forms Plus add on? "EFP"?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

markshnier__you · Answer

Are you asking how to pull data from a child record up to the parent? If the Parent has 20 children, which child record's data needs to be pulled up?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

mikeklausing · Answer

Mark, &nbsp;I want to take this "1" and be able to display it on a form separate from all of the other information in this table. &nbsp;Because if I move the entire table over to a printable document I have to box it in like the number" 2" below. Where the rest of my document has blanks running along the left hand column. I want to single out the table into multiple pieces of information so I can place them where I want, rather than only being able to control the table as a whole. &nbsp;Thank you, Mike Klausing&nbsp;------Original Message------Are you asking how to pull data from a child record up to the parent?&nbsp; If the Parent has 20 children, which child record's data needs to be pulled up?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

markshnier__you · Answer

&nbsp; &nbsp;I think that in your case you may want to get into reverse relationships. That is a technique which allows you to look up data from child records up ti the parent.To set up a reverse relationship you make a summary field of the Minimum of the Record ID#, possibly subject to a filer on some field. For example, perhaps you know that the child lines have a hook like a certain value in a description field. So maybe the field would be called Record ID# of 1stThe you make a new relationship where 1 child has many Parent. yes backwards, hence the name for the technique. On the right side of the relationship you select that Minimum Record ID# field. That will allow you to "lookup" any fields from a particular child to the Parent record.I know that this is just a partial response as I don't understand the nature of the data in the child table.Then you can also make a summary field of the 2nd minimum record ID# by looking up the 1st minimum record ID# down to the child table and then making a new Minimum record ID# field subject to the filter that the Record ID# is greater than the 1st Minimum Record ID#.So, while this can be done, if you have a lot of children, or an unknown number of children this technique starts to get out of control.&nbsp; &nbsp;------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

Forum Discussion

Pull particular fields from table on form

Related Content

How to relate two tables with the key to a third table?

Child Table Field Question

Table is missing

Reference tables quandary

Consolidate Field Types