Help with this SQL...

[nanscombe]

I've been having another think.

I have been assuming that the the card we have been talking about payment cards.

If you are talking about collectible cards then maybe the ID would be better in tblInventory.

You could then have the structure

tblInventory -> tblTransactionID

You could then have a Form for the card and a Subform for the transactions.

 

[hunterfan48]

Nigel,
Thanks so much for your hard work and effort! I really appreciate it. I should have clarified earlier that by cards I meant collectible cards...not payment cards. I like your ideas and think they are valid, but I think a better option has presented itself. I had a suggestion from another member to create two more fields in my tblInventory for buyingtransactionID and selling transactionID, thus eliminating my linking table (TransactionID).

Although it will take a great deal of manual inputting and changes, I believe it will be for the best. I'll be sure to keep all of you posted.

Again...thank you all for your help. Everyone on this forum has been extremely helpful in creating my database. For that I am very grateful.

Thanks,
Brady

 

[nanscombe]

Well if you need any ideas to speed moving the data around ....

 

[hunterfan48]

Yes in fact I do! I'm trying to manually enter values for 1,095 records. That's a lot of typing! LOL Any quick solutions?

 

[nanscombe]

I would ...

a) Write a Make Table query to create a temporary table based the ID from tblInventory and any relevant fields from the Buy and Sell queries. I think you've already got some ideas on a select query that give you the source of this.

b) Add the new fields to tblInventory

c) Write an update query linking tblInventory to your temporary table, using the ID, which should allow you to update the fields you are interested in.

 

[hunterfan48]

Got it...thanks!