What I am trying to do is have a sub-form so that you can put the product in and they enter the information that you see that is above. Then when they click to go to a new record it starts a fresh record so that someone else can do it. But the order subform keep the information from the last person. How do I change that? I know I have to create a relationship but not sure what I am doing wrong. I have included the database with the word document in the downloads.
thanks! Steve ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
