Auto create new widget

[nshenry03]

I have a main table that keeps track of various things and then I have another table that keeps track of widgets for example. In the main table I have a lookup combo box so that the user can choose from several widgets and select one, but I want the user to be able to enter in a widget from the main form as well.

So. for example

Main form/table
-----------------
ID FName LName Number widget
1 John Smith 32 Red widget
2 Jamie Marie 512 Green Widget
3 Jennifer Jera 145 Green Widget
...

Widget Form/Table
-----------------
ID Description
1 Green Widget
2 Red Widget

Is there any way for a user to enter in a Blue widget for Jane Doe and automatically add a blue widget to the Widget form/table?

 

[Remou]

If the widgets are in a combo box, you could use the Not in List event.

 

[nshenry03]

Hey, thanks a lot