Using Subforms

[Guest]

I am creating a form using a subform. I have 2 tables that i am accessing
the data from which I have created a relationship for. I would like to be
able to access the data from one table so I do not have to create a
relationship with another table. The one table has all the info i need to
access. But when I try using the one table and i run the form by entering a
stock code, it will replace my first record with the stock code I just
entered. Ex. My first record is 0001M and I enter 00446 it will give all
info of 00446 and replace 0001M with 00446 therefore giving that 0001M stock
codes info. And if I were to enter another stock code it does the same thing
in that it replaces the stock of the first record.

I notice when I have the relationship set up it does not do this and
everything works fine. The reson i do not want to have a relationship is
that I have make table and append table queries which will not work unless I
delete the relationship. Which means i would have to recreate the
relationship once i'm done updating the table.

Any suggestions on how I can use the one table?

Thanks
Linda

 

[tina]

if you're unable to run append queries without deleting a table
relationship, then there's a good chance your tables/relationships are not
defined correctly. what are the two tables? what data do they store? what is
the relationship between the two tables?

 

[Guest]

The 2 tables are inventory tables and the relationship is on the stock code
field. The relationship is not created in the query section but under the
relationship module. And in order for my form to work I need to have this
relationship.

Thanks
Linda

 

[tina]

Linda, i think we could do a Q&A on this for a day or two, while i try to
get a picture of the setup and how it's affecting what's happening. i'd
rather cut to the chase. if you'd like me to look at your db and see what
the problem is so i can suggest a solution, post your email address
(disguised, to foil the spammers) and i'll email you.