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