Tables and Relationship.. am I in rt Derctions ?..

[khalakmu]

Hi,

I am looking some advice if somebody can guide me in right direction.. would appreciate
very much. I am building Database as follow...Using Access 2007. Have two questions

Question One...

1. tblCountries (countryID pk auto,tcfld1 txt index uniq,tcfld2 txt)

2. tblIssues (IssueID pk Auto,IssueId fk no,IsuCategoryId fk no, Title txt,Isufld2 txt)

3. tblIsuCategory (IsuCategoryID pk auto,Category txt)

4. tblIssueDtls ( IssueDtlID pk auto, IssueId fk no,spck1,spck2,spck3,spck4 "mostly spck are fields
from Other Lookup Tables"...)
5. tblIsuItems (IsuITemID pk auto,IssueDtlID fk,ItemCode txt, Price, ItemDesc txt Indexed, color, size
ItemFormat txt)
to me looks Relationships are right..
tblCountries 1:M tblIssues
tblIsuCategories 1:M tblIssues
tblIssues 1:M tblIssueDtls (I seperated out tblIssueDtls thining that at some point
if any one or more of spck defferent Issues are more than
one with seperate specifics)
tblIssueDtls 1:M tblIsuItems..

I created form Based on tblIssues,tblIssueDtls and tblIsuItems via FormWizard I get nested
Form and subforms.. I would like to know How I make Mainform Based on tblIssues then Put
Page Tabs and and other two forms (creating seperate forms from Those Tables namely tblIssueDtls
and tblIsuItems.. so that related info I can add on those pages.

Question Two

Now if I want to know Howmany of IsuItems I have and where Location,PurchPrice,Saleprice Is... Sould I

Create a seperate Table e.g. Invetory Table.. with fk IsuItemID... with One to many or many to many ?
Or create tables Invetories,Transections,CustOrders,PurchOrders...and relate them relationaly and
make form based on Either Transections or Inventories Table Having Unbound Text Field To find
what Item I have mostly buying occasionally selling or Despose off..
I am still working on second question. I can ask if needed again.

At present I am more concentrated on First one...
Please help me in Learning Access 2007. this is not any work assignment or commercial work
just bits and Pieces from books,forums,Crystal's web and my imaginations.My Main Problem
comes from that In Past most of my fun Dbs were in dBaseII to VisualdBase and Delphi..
so I develope Procedural Habit... so now and then I get mix up in to...of and on I tried
various times Access.. I have my very first Access (time of Optima,dBase and Paradox..)
Bits and Pieces of valdocs,Basic,Pal,PlSql...I know hae practiced BUT SOME HOW I FIND
LEARNING CURVE IN ACCESS VERY STEEP... THAT is why I on and off dropped Learning Access
I have quite Few Books for Access.

Thanks in advance ... any any help would be highly obliged and Thankful.
NB: I have asked same question in Other Access Forum.. I dont know it is called cross Posting or not... if it is please forgive me.
Khalak cheers

 

[Jeanette Cunningham]

tblIssues, tblIssueDtls and tblIsuItems are the main tables.
tblCountries and tblIsuCategory are lookup tables.

To make a form with tabs, you can start with the wizard-created main form based on tblIssues.
Delete the subforms and put a tab control on the form.
On the first page of the tab control, put the subform based on tblIssueDtls.
This subform could have a nested subform based on tblIsuItems.
Use the above form with tabs for Data Entry and Edits.

To see "IsuItems I have and where Location,PurchPrice,Saleprice Is"
Build a search form – my favorite search form is here
http://www.allenbrowne.com/ser-62.html
The search from will be very helpful for searching on issue details and issue items.
Post back as you need more help.

 

[khalakmu]

Thank You very much Jeanette.. appreciate very much.
I will Try again... and come back.. after that I have to concentrate second part for
Items ... Purch and sell and total item inventory..
Its very encouraging that I can come back and ask again..
Thanks and Regard.
khalak

I did it. But on First Page tab... both subforms are in cascading format.
what I would like on frmIssues have Page1 which will show sffrmIssuesDtls
and on Page2 tab sffrmIssueDtlsItems. Sybcronised way.
thanks
khalak