Displaying results of query in form text boxs

[mgillespie21234]

OK so here's this situation: I have a Inventory DB and i want to integrate scanning. So far i have a table called StockInfo, this table holds information about bar codes (device type, make, model). I have a form called Scan_Barcode, on this form I want to be able to scan a bar code into a text box (text0) and use a afterupdate and requery function (I think... need some help) to display the results onto a form called EnterInventory. Not only just the results but I want certain columns from the query to display in certain text boxes on this form. I have a query called FindProduct. that filters the criteria by whats entered on the Scan_Barcode text box (text0). So when i scan a certain bar code i can get the query to display certain product information for the bar code. I just cant get the results onto the HarwareStock form. PLEASE HELP!! I will be happy to clarify if this is confusing.



Search barcode Form

Find Product Query

Hardware Stock Table

Enter Inventory Form

Stock info table

[June7]

Options:

1. dynamic parameterized query that references the barcode textbox as input - I never use this method

2. I prefer http://www.allenbrowne.com/ser-62.html

What are the PK/FK fields on these tables - how are they related? It doesn't matter what kind of input device you use (keyboard, mouse, scanner) if the tables have no relationship.

Is StockInfo a 'lookup' table for product info? Need to save either barcode or StockInfo ID into HardwareStock. Should not have Device, Make, Model fields in both tables.

[mgillespie21234]

Yeah your right I was just reading about pk and fk and have thr general idea. I will make some changes and post new pics Monday... Thank you June!

[orange]

If you really do not know what a PK or FK is or their significance, the work through this tutorial. You will learn about database tables and relationships by working through a process that can be used with any database. You have to work through it, but you will learn.

Normalization