Question Need Help with Nested Data / Form

[fenstantra]

hi guys need help with nested data
thanks before and sorry if my english bad

i have 4 form
form 1 = Date In
form 2 = From
form 3 = Item List
form 4 = Serial Number

this is my relationship pic
see attach file relationship.jpg
this is what i want to make
see attach file error.jpg

the problem is:
1. when fill same supplier but different date = can't
2. when fill same item but different date & supplier = can't too

what i want is for example on date 5/8/12 supplier alex sent keyboard and mouse, and 6/8/12 alex sent again keyboard and mouse
how to solve that
thank you

 

[jdraw]

I suggest you read this article on relational data base.
http://forums.aspfree.com/attachment.php?attachmentid=4712

Also, do not use field and object names with embedded spaces or special characters.
see this link for examples http://accesstips.datashark.co.uk/namingconventions.htm

For your own benefit, write a 3-4 line description of what your application/database is about. It will help you understand the "things" you are dealing with, and will facilitate creation of relationships.

Use meaningful table names. I don't think FROM is a meaningful/communicative table name.

Good luck with your project.

 

[fenstantra]

thank for your reply
can you give me more link or tutorial for understanding access basic because im still very new and no basic at all, just started to try make access 5 day
also can you give me link or attach access file too, so that i can learn more easy

thank you so much
sorry for my bad english