INSERT INTO model ( model, supplier_id, equipment_type_id )
SELECT ([Please enter new Model:]), hardware.supplier_id, hardware.equipment_type_id
FROM hardware;
Hi, hope you can help. I've looked on the net but can't find understand anything relevant.
In my main form the user selects a...
OK, I feel really silly for having to ask this but I can't work it out...
I need to add a simple bound text box to a form in design view.
However, it's not listed in the field list so I can't just drag & drop it and if just draw on a text box then click properties, control source, [...], and...
I have 3 combo boxes and I would like them to interact as follows:
Equipment Type - (e.g. PC, laptop)
Regular Drop Down
Supplier - (e.g. Dell, Toshiba)
Shows only suppliers of selected Equipment Type
Model - (e.g. GX270, 2410-703)
Shows only models of selected Supplier AND Equipment Type
I...