Hi,
I have 2 tables:
Table "A" and Table "B".
I tried 2 methods for a linking.
First method: Using a Ref column in A with B as the Source Table
Everything works well as I see in some tutorial videos .
Second method: NOT Using a Ref column in A
I only put a virtual LIST column in "B" with the REF_ROW(Tabla A, id_B) formule.
I had the same result with the 2 methods .
I like more the second because I could use more than one table connected to Table "A"
QUESTION: Is there some difference between the 2 methods?.
Thanks!!
With the second method, you'd be missing out on a lot of useful capabilities of a Ref column. Like dereferencing, or being able to view the referenced record's label instead of its key.
https://help.appsheet.com/en/articles/1090811-dereference-expressions
https://help.appsheet.com/en/articles/961466-row-labels
https://help.appsheet.com/en/articles/1023086-what-is-a-key
What is the point of doing the second method, what would you achieve? "use more than one table connected to Table a"? Not really sure what you're describing there, but you can already connect a table to multiple other tables.
Hi Marc:
Thanks for your answer.
This is my REAL problem:
In my work (factory) we have some employees who make cleaning process :
Offices, Bathrooms , Production area, etc.
Every time that they clean some area they fill a form with a checklist . For example for Offices: Windows (yes/no), Tables (yes/no) and the Floor(yes/no) Every area has his own checklist.
That becomes that I need a data Table for the "Bathroom", other for the "Production area", etc. We have more than 20 areas.
All the registers are supervised and every time that has detected a bad execution we have one or more "DEFECTS".
This "defects" are categorized and global for all the areas.
Example:
If we only had one possible defect for every area I would put some extra column in every "Area Table" filled by the supervisor . In real life we could have more than one.
That becomes that I need a "DEFECT TABLE" and then I need to put here an ID for the execution of the cleaning area , "The Defect kind"( example "the employee lied..") and a text description.
If I use a REF column in the "DEFECT TABLE" I can only put one table on the Source Table.
THAT is my problem. I think I understand what you said "..able to view the referenced record's label instead of its key". Really in my solution I need to use in the "DEFECT TABLE" a column with a Lookup formula to know what area is.
My modest solution work for me now, but a would like to know a better solution.🤓
Thanks for read me!
If I followed this sufficiently (which I'm doubtful of), you should combine all of your area tables into one table, with an [area] column.
No, I can not.
Because every Area Table is different one for each other, and has different column number.
Example :
The only thing, that these tables have in common is the classification of the "cleaning problems".
I can't make any sense of this.
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
12 |