View Single Post
  #31  
Old July 30th, 2007, 07:30 PM posted to microsoft.public.access.queries
Moe[_2_]
external usenet poster
 
Posts: 7
Default Please suggest relationships model

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