Hi. I have several records against 1 JobID and REF_ROWS setup correctly, however no records show in the inline form? Can anyone help?
Can I see the structure of the โappQuotes.csvโ table?
As attached, Thanks
Try placing the โjobidโ field as a reff type and pointing to the primary table.
The virtual column with the referenced fields must be created automatically.
That didnโt work unfortunately. Regards
What other table has apart from โappQuote.csvโ?
I think I have it. QryTransport.csv has a numeric โkeyโ column, AppQuotes.csv has a text โkeyโ column.
How do I fix this guys?
Cheers
you have to relate those two tables.
by means of a reff column
In the โAppQuotes.csvโ table, place a new column called โIdQtโ(NO virtual) of type reff and in the Source table configuration select the โQryTransport.csvโ table. in the excel sheet โAppQuotes.csvโ in the โIdQtโ column you will place the ID codes of the โQryTransport.csvโ sheet that relate to โAppQuotes.csvโ. This article can serve you:
Hi Fredy, all sorted now thank you, I added a different column and synced the two together, all is well in the app world.
Kind Regards
QryTransport.csv holds the REF_ROWS(โAppQuotes.csvโ,โJobIDโ)
From the view โTransportToday_Detailโ there is an action, which goes to another view within this app: LINKTOFORM("AppQuotes.csv_Formโ, โRefโ, [JobID],โJobIDโ,[JobID])
The JobID is carried over to the AppQuotes.csv_Form, the rest of the data is enterred and saved.
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |