is it possible to have 2 tables or fields from two different tables in one form w/o main and subforms or a query? i just need one table as a lookup thats..all. i tried using query and subforms but it affects things that i want to accomplish. is there another option?

The only way that I know to accomplish what you want is if you do make a subform to handle just the lookup field. Embed this subform within your main form and click on the window of the subform to get its properties. Set the Special Effect to Flat, the Border Style to Transparent and the Border Width to Hairline. That way it does not look as though it is a subform. Make sure that there are no Parent or Child Links set up.

One way to do this is to create comboboxes for the fields with lookup values. For example, if you have a form that displays payments to a salesperson and the table stores a code but you want to show a description, create a combobox (using the wizard) for the code field, bind the code field but display the description so payment code 123 will show as "Commission", 456 will show as "Bonus", etc.