Lookup Wizard

Ok so 2 questions on lookup wizard in tables

First... So I was using lookup wizard to make a nice dropdown menu of options populated from another table, which would then force a relationship between those 2 tables... fine... however it was forcing it to be a number instead of short text as datatype in the table with the dropdown menu

When I went and deleted the relationship so I could mess with things it still had the dropdown menu as well as when I edited the other table, the dropdown menu was edited with it... how is this possible with no relationship between the 2 tables? and is this a safe practice to use since its allowing me to change the datatype to what I like.

second... is there a way to use this sort of lookup wizard in forms? ultimately I don't want to add data at the table level itself I want to make forms to do it in... and I know how to do most of what Im trying to do in the forms however im unsure how to do this.... I want to force the selection of options into a combo box basically and not allow any option except what is in the table that the combo box is populating its list with.

Thanks.

ok, thank you ya it wont hurt anything for me to do it in a form instead of a table so Ill make that change asap

Great info! 1 followup question to those vids... from what I learned in Vid 2 about linking multiple combo boxes...

Now I know setting it so if you have 2 combo boxes (Publisher) (Series) you can have it so if you pick a publisher it will only show the relevant series that are in that publisher..... but can you also do it the other way so that if you pick the series first, that the publisher automatically gets picked foryou?

Thanks.

Ive even tried some VB Code to do it lol which didnt happen right

Me.adseser.RowSource = "SELECT ID, Series_Name " & _
"FROM Series_List " & _
"WHERE Publisher = " & Nz(Me.adsepub) & _
"ORDER BY Series_Name"

Id assume I did something wrong there