Table lookup without a user selected proxy
I have a budget table and a survey table. I want to pull in budget pricing on each category based on a customer name but do not want to have to select a proxy, I want that to be selected for me so the...
Forum Discussion
The relationship at this point is One Budgetsto Many Surverys. The budget table is not linked to a Customer table but could be. The surveys are tied to a Company table so the company name is there in the survey. At this point I do not believe we would have different budget pricing per customer but you know if you do not think of it now it will happen. Just thinking ahead!