hi anyone i need help

[babyvoid]

hi guys im new to access i tried different tutorial but seems i cant still get it.. my problem is i have this fields i dont know how to relate them... product name, brand, ( note each product name have different serial number), date in, date out(sold to customer) Quantity in , Quantity out, Balance.. for example a watch i have 3 units this 3 units have serial number of Abc1, abc2 abc3.. help me please

[June7]

All I can do is refer you to more tutorials. Review the 'sticky' threads at http://forums.aspfree.com/microsoft-access-help-18/

Maybe on-line tutorials not enough, get some books - used, cheap from Amazon.

[Neopoetess]

I'm new to Access as well babyvoid! I'm so afraid my questions will be so simple as to be thought stupid. I have an Access book but it has little in the way of how to write code, what the proper way is to write syntax, how to build expressions or write macros. I need an Access Bible, but it seems some things are a big secret like Time/Date differential.... though some people know everything about it . I have one stickler in a Total Hours column that is driving me bananas right now. Good luck w/your venture. I'm off to find THE answer.

[ssanfu]

@babyvoid

Here is another link to a tutorial by Crystal. It is pretty basic. One concept you really need to understand is normalization.

http://www.accessmvp.com/Strive4Peace/

[mslenker]

What are the tables you are trying to create?

hi guys im new to access i tried different tutorial but seems i cant still get it.. my problem is i have this fields i dont know how to relate them... product name, brand, ( note each product name have different serial number), date in, date out(sold to customer) Quantity in , Quantity out, Balance.. for example a watch i have 3 units this 3 units have serial number of Abc1, abc2 abc3.. help me please