Is it possible to add dummy dropdown fields on an add record page in order to filter other dropdowns, but not actually add this field to the table?
My form has a number of fields like 'Hardware Name' which have amny options, and I would like a 'Customer' dropdown in order to filter these options, However, as the customer ID is already stored against the Hardware in another table I dont need to record that here. Is there a way I can add a field (in this instance as a dropdown dropdown) as a dependancy for other dropdowns, but without actually storing this field?
I did try adding the following into my SQL query:
,'' AS DummyField
And then this field is only on the Add page and provides what I need to display the form, but breaks as that obvisouly then tries inserting into this non-existent column. I believe I could do this with a view or adding a JOIN to the SQL to reference another table with Customer ID's, but then I think that would do the JOIN every time the list page is viewed etc which is probably inefficient when its only needed for an add.
Any ideas appreciated, I'm sure I'm missing something obvious. Thanks.
Jim.
