Adding data to tables

[HunterEngineeringCoop]

Hi all,

I'm looking for a good way to have my database users update lookup tables. For example, I have a table that lists all the inspectors at our facility, and there should be a way to easily add new inpsectors to this table.


I have considered creating a button that opens the table so they can directly access the table but this seems less than ideal. If anyone has any good approaches to this problem, I would be very grateful.

Thanks in advance,

[pbaldy]

I never let users into tables or queries; they only see forms and reports. I would have a form for them to maintain the inspectors table. If there are several tables, I'd probably have a "Maintenance" option on my main menu that opened a form with options to open a form for each of the tables (5 tables = 5 forms = 5 buttons on this form).

[HunterEngineeringCoop]

I agree. I do not want to give them direct access to the table. I'm looking for a good way to let them edit the table. I tried making a continous form where each form is only the name from the table and it seems to work pretty well.

[pbaldy]

I should have mentioned a continuous form. That's what I typically do.