The tblWire is just like the inventory table... I named it like that because
the inventory is mainly wire.
--
Moe


"Gina Whipp" wrote:

Moe,

The image of you relationship model seems slightly different then what you
origially asked for. Where does tblWire fit in the original design? You
can skip past this and get your answer located at the bottom of this
response, I am just adding my 2 cents regarding your table design.

For table design you might want to consider (I may not have taken into
account all the fields you may actually need):

tblInventory
iInventoryID (Primary Key)
iDescription
iQuantityOnHand
iCost
iVendorID (Foreign Key) - Only to be used if Vendors other than yourself

tblProjects
pProjectID (Primary Key)
pDate
pDescription
pAddress1
pAddress2
pCityID
pZipCodeID
pPhoneNumber
pFaxNumber
pMainContact

tblTransactions (This set-up is if you using Tranasactions agaist Projects)
tTransactionsID (Primary Key)
tDate
tInventoryID (Foreign Key)
tProjectID (Foreign Key)
tQuantity (Which is QuantitySold or Purchased)

If there is a Vendor then add this table

tblVendor
vVendorID (Primary Key)
vCompanyName
vAddress1
vAddress2
vCityID
vStateID
vZipCodeID
vPhoneNumber
vFaxNumber
vMainContact
vWebpage

But to answer your question.. You will need a subform that would attach to
the form you already created (One-to-Many) so you can see the transactions
as they relate to the one project.
--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

"Moe" wrote in message
...
So, after reading a bit, I managed to come up with this model
http://xs317.xs.to/xs317/07311/rel.JPG

That kind of does the trick... I'm just missing one little detail here,
and
I'm kind of stuck

I ran the wizard to create a form using the tblTransfers table as source,
came out like this:
http://xs317.xs.to/xs317/07311/fTransfers.JPG

The only problem here is that one of my transactions may include several
items.
How would I accommodate that in this form?

Do I need maybe an additional table to hold more information? if so, what
kind of information would this contain?

Thanks again
--
Moe