Skip to main content ↑ ↓
Topic: add to lookup table if item doesn't exist (Read 1279 times) previous topic - next topic

add to lookup table if item doesn't exist

In Access you could have a table called Cars say and a form would have a drop down of all the cars from this table.  But if the car you wanted wasn't listed you could add it manually and it would then become part of that table for the next person to add an entry.

Is there a way to do this with php rad?

If so could some one please explain how i can do it please.

Thanks

 

Re: add to lookup table if item doesn't exist

Reply #2 –
I have found a work around to this.... if you use the insert table itself as the look up table e.g.

Table Called Users;

ID
Username
First name
Surname
Role

Use the dynamic look up (the one where you type and not select) against the role column. So if the role exists then you can select it, if it doesn’t it offers you to add it.