Form Design

  • Thread starter Edward Jones (Eddie)
  • Start date
E

Edward Jones (Eddie)

First i will give a brief diagram of the tables and form then describe my
issue:

tblContract
-------------
contractID
description

tblItem
-------------
itemID
description
contractID

tblCurUnits
-------------
unitsID
units
price
itemID

Therefore if a contract had 5 item assciated with it every week i would go
into a form similar to:

------------------------------------------------------------------------------------------------Contract Description: tblContract.[description]
ID Description Current Units
Current Price
------------------- --------------------------
-------------------------- -------------------
[tblItem].[itemID] | [tblItem].[description] | [tblCurUnits].[units] |
[tblCurUnits].[price]
[tblItem].[itemID] | [tblItem].[description] | [tblCurUnits].[units] |
[tblCurUnits].[price]
[tblItem].[itemID] | [tblItem].[description] | [tblCurUnits].[units] |
[tblCurUnits].[price]
[tblItem].[itemID] | [tblItem].[description] | [tblCurUnits].[units] |
[tblCurUnits].[price]
[tblItem].[itemID] | [tblItem].[description] | [tblCurUnits].[units] |
[tblCurUnits].[price]
 

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

help required in designing an inventory form 6
Moving data into a new table once selected from a form 9
Form Design at Run Tine 1
Filter form based on query result 4
Trouble with composite keys 2
Invoice Amt. - Payments = Balance 2
HELP WITH DESIGN BASED ON MOVEMENT OF ITEMS 1
database design issues- tracking item movement 0

Top