Forms and Tables

G

George Schneider

Here's something i'v ebeen racking my brain with and can't seem to get anywhere with it. I'm trying to create a form that will allow a user to enter freight cost,pallect charge, and misc charges. I have a query that pulls order number, vendor, received date, part number, description, ordered amount, and price from our linked sql tables. I figured for the user entered information i'll need a table. I need somehow to realte the two tables. The easiest way would to have a common field such p.o. in the one table and link it with the sql table. Any idea how can accomplish what i'm trying to do.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Multiple Tables 1
List all tables, including document structure 0
Creating a Search using a combo box and then creating a report. 4
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Confusion with forms and related subforms 3
Help with tables. 2
show 2nd field when combo box choice is made 4
Checkbox will not check 5

Top