Hello,
I am trying to create a system for tracking renovation jobs. Right now I have a table for tracking jobs, line items, and expenses. I want the line items and expenses to be references to each job, and that's what I've done. However, I also want to have the option to add an expense to a line item. To do this, I've added another ref column in the expenses table. This works, but when I go to select a line item, it shows me the list of ALL line items, not just the ones associated for that job. Is there a way to filter or slice a reference?
To clear things up:
'Jobs' table has no references. 'Line Items' table references the 'Jobs' table. 'Expenses' table references both the 'Jobs' and 'Line Items' tables.
When I add an expense, I want to select a job (automatically) and then manually select a line item, but only from the list of line items associated with that job.
LinkedIn
Twitter
