Make-Table Query

[Charmed7]

I am in no way an experienced database programmer. My company just bought a program that is written in Access. I'm working with Access 2000. I have my database with a linked table from the main database. This is actually coming from a query.

So my problem is the linked table will not create the relationships I want. So the only option I have come up with is to copy the data into a new table. From my little experience with Make-Table queries, they will copy the data and duplicate it everytime you copy. My linked table is live data, so when ever someone enters a new record, I have to add data to it (the purpose of this database I'm working on).

My question is, is there a program I can write so I push a button, and all NEW data is added to my table (from the linked table)?

Thanks in advance for your help.

 

[Charmed7]

relationship

Well, I guess so. I have one linked table that has a one to many relationship with my table. When I keep it linked, the one to many is backwards. Which is why I felt this wasn't going to work for me. I do query reports from all my tables so I would think the data would be inaccurate.

If you want me to get into a few more details I will, but I'm pretty sure the linked table is giving me more headaches than being helpful.

 

[Charmed7]

The main database is blocked, and no one can work off of it. It's also very complicated for this little girl, so we created a virtual table compiling the information from the main databases tables and linked it to a seperate database for me to work on. Yes, the primary keys are my problem, and yes the live data is important to me.

Your last statment "the purchased db is actually a fe and be rather than a single db. If it has a separate be, just add your table to the be and enforce RI and Cascade Delete." doesn't make any sense to me. You are using fe and be and I don't know what that stands for.

The RI (I got that one ) may not be that important to me. A quick break down of what I'm doing might help. Thanks again for your help.

We issue policies. Each policy has an Invoice (one to many). The invoice is what I am working off of. Each invoice has some information my client wants a report on. Maybe 1/3 of that information is in our main database. So I have linked information that includes a policy number, an invoice number and some other information (such as zipcode, name, type of policy etc). I than have a lot more data that needs to be entered for each invoice. (That we have a data entry employee working on). So I am creating forms for her to input that data. I will also be responsible for creating the report for my client. I'm trying to tackle each obsticle one at a time. So Accounting department creates new invoices constantly throughout the day. I then will get a report of what new invoices were done from yesterday and have the new data inputted.

If the RI doesn't matter, then would refreshing a copied table be easier? Can you help me with that? Or do you see another way?

 

[Exodus]

fe = Front End
be = Back End

A typical set up for multi users over a network.
Is there any support for this application?
Do you need a password to get into the database?

 

[Charmed7]

Well, I went into the database, and found I could add a table. I thought they had it all locked up. I don't know if this is going to solve any problems, but I'll give it a go. If anyone else has any other advice regarding the issues above, that would be great. I'm sure I'll be back with more questions

Thanks again for your help.