I have a drop down list of customer rates that can be selected when creating a bill. I have a Customer_Rate_Card table linked to the client, bills for that Customer will present a list their rates. Nice and clean.
But now my client wants to have additional options that are universal to all clients. He does not want to add them to each rate card, understandable.
I could add them automatically and hide them but that get complicated if in the future he want to edit those universal rate.
So is there a way to combine two tables into a single drop down list.
And, if so, how could I have it filter the drop down for one table to only the records related client and for the other show all.
I suspect the answer is to automatically add, hide, and write scripts to update when changed. uuuuggg....