AnsweredAssumed Answered

Not sure how to show relating records in value list

Question asked by informationator on Nov 21, 2017
Latest reply on Nov 21, 2017 by philmodjunk

Hi there,

 

I for some reason cannot show relating records in a value list.

Consider the ERD at the bottom of this post.

 

For simplicity I will refer to RFQ as a Quote, and you can think of it like that for simplicity.

 

job_RFQ_ITEMS is a table which lists the line items of a quotation (There is another table not shown which has the quotes in it)

 

job_RFQ_ITEM_SPECIFICATION is a list that shows all of the individual specifications of the line item. (These are dynamic and creating another table was necessary)

          Examples of data:      _id    |     Type      |     Description    

                                               1     |   Material  |     Metal

 

rfq_supplier is an intermediary record that relates RFQ_Items to Factories that will supply the item.

 

 

rfq_supplier_FACTORY is a table of all suppliers / factories that a quote item could be made from.

 

 

I am in a layout which has a table occurrence of rfq_supplier_factory and is used to search for different factories. You can select a Factory which then adds the record to rfq_supplier. The solution uses global variables to remember what RFQ_Item you previously selected.

 

I am trying to create a value list on a layout which has the table occurrence of 'rfq_supplier_FACTORY' which is used to search the different RFQ_Item-Specifications which relate to the RFQ_item which ultimately will be inserted into RFQ_supplier as a record. (Described in above paragraph)

 

 

How can I achieve this?

 

 

Regards.

 

 

Screen Shot 2017-11-22 at 2.21.49 PM.png

Outcomes