Forum Discussion

GeoffreyHarmuth's avatar
GeoffreyHarmuth
Qrew Captain
7 years ago

Convert comma separated values to new child records

So i have a Table for Job cards and a second child table for parts used.  These 2 tables are connected with a Line items table: Job Card --<Line Items >--Parts I have a third party app tha...
Forms
GeoffreyHarmuth's avatar
GeoffreyHarmuth
Qrew Captain
6 years ago
Hi Dan.  I'm busy implementing this but I have hit a small snag:

In your example, you work with 2 tables [Parent] and [Child].  I have 3 tables:

[Parent]-<[Line items]>-[Child] - > with the line items table being the connector of the 2.  I've done this because I have a set list of items that can be chosen from the child record.

How would one work this type of scenario?




GeoffreyHarmuth's avatar
GeoffreyHarmuth
Qrew Captain
6 years ago
Hi Mark.  Is there any way i can get this to work without doing automation?  I dont want to go and add another 60 odd fields just to cater for the unknown limitation of items being added.


I like Dans idea, but it exceeds my current skill level to implement.  Dont mind working off line if you feel its too complicated to post here.

Will appreciate the help