Linked Table problem

[sha7jpm]

I have a colleague who has a main dbase and a data entry dbase. the two main tables within the data entry dbase are linked to the main dbase......!!!

she wants to make one of the fields in the data entry dbase a drop down list, but becuase the table is linked it cannot be modified.

is there any way to bypass this..?

a form exists for data entry purposes so theoretically a combobox could be put in there with some coding.... to link it to the table.

any pointers??

 

[Fizzio]

The field only stores the information in its native format. How you get that information is up to you! ie combo, textbox, listbox etc. If you are inputting the data via forms (which is safer and more pleasing on the eye), you can change the type of control to combo by going into the form design mode. Remember though that a combo gives you a choice of values to choose from so you need to tell the combo where to get the values from (its rowsource). HTH