Hello All,
Very Simple....

I have:
tblSID
Support_ID
SupportLevel ( I want to make this a combo box)
SupportType (this To)

Does that mean i need to do this:

tblSupportLevel
SupportLevel_ID (Auto)
SupportLevel (Text)

tblSupportType
SupportType_ID (Auto)
SupportType (Text)

tblSID
Support_ID
SupportLevel_ID
SupportType_ID


Then wont the Form SID display a combo box with the ID's and not the Support Level....

I know im making this into more than it needs to be... I just need some reassurance


Thanks for the help!

If you use the wizard to create your combos it will automatically hide the key column and just display the text. This is done by setting the first column width to 0.

Perfect! Thanks Scott... I just started reading your book!

Thanks again,
James

Someone bought it?

>> Perfect! Thanks Scott... I just started reading your book! <<

Woo Hoo! ... 20% of that puppy is mine ya know!! ... ...

O nope .. sorry to dissapoint

its Access 2007 VBA programmer's reference / Teresa Hennig
no worries its an ebook through school so i didnt pay for that one either!

thanks for the help though!

... So my grandmothers cousin by marriage, despite the two divorces, named Susie is still the only purchaser ... bummer!

I dont know what your contract is like with the publisher but maybe you can offer it for free distribute to some major universities? Just an idea... Get your name out there

Good Luck!