Hello, I have been trying to find a posting here or an example that could give me some guidance. I have 5 tables that has information in them, each table is a article type for my magazine archive and one for the magazine issue itself.
So say for example: you want to read all articles ( i am archiving 10 years worth of model building magazines, scanning the pages and hyperlinking them from local pc) pertaining to a p-51 (tblsubject) airplane in 1/48th (tblscale) scale from Revell (tblManufacture). I would like to search all articles and find all records that meet such criteria. I see examples of searching for data in one table but across many i cant find.. I tried to impliment an example with a queary that had all my tables in them.. what i got was a result with each table going sideways (make sense).
I am ok with having a result box for each article i guess.. but would REALLY love having them all in one list going vertical down. I may be asking for something impossible but would like to know if anyone has any idea how to go about that way. Now, FYI, other than being in each tbl there is nothing that says a certain article is a tblreview or tblbuilds (as in no field to mark the type of article it is).
I am still very new to VB and Access but not afraid to poke around and brake my test database.. so please keep that in mind..
Here is what each table looks like:
Here are my Constant tables that share the same data, each article table (tblreviews,tblinfo,tblbuilds,tblhowto) shares.
tblScale:
ID: unique ID
Scale: unique scale, no duplicates (ie: 1/48, 1/72 etc)
tblManufactures:
Manufacture_ID: unique ID
Manufacture: unique manufacture, no duplicates (ie: Revell, Tamaya etc)
tblSubject:
Subject_ID: unique ID
Subject: unique subject that will not duplicate (ie: p-51, p-38, etc)
-----------------------------------------------
tblMagazine:
Magazine_ID: unique id (this is how articles are linked to a magazine)
Magazine_Title: Name of magazine (linked from tblMagazine_Title)
Magazine_Month: Issue Month
Magazine_Year: Issue Year
Volume: Volume of magazine
Issue: Issue of Magazine
Cover_Image: hyperlink to a local image on pc
------------------------------------------------------------
Here are my Tables, These are the tables in need to search.
tblReviews:
Reviews_ID: unique id
Reviews_Subject: Subject of the article (ex: P-51, or P-38 etc)
Reviews_Scale: 1/48, 1/72
Reviews_KIt: number to kit, (ex: 46-545)
Reviews_Manufacture: tamaya, revell, etc..
Reviews_Magazine: this is what links the article to the tblMagazine unique ID
Reviews_Author: Author of article
Reviews_Image: hyperlink to local scanned image on pc
tblInfo:
Info_ID: Unique id
Info_subject: same as above
Info_Magazine: links to the magazine ID
Info_Author: same as above
Info_Image: same as above
tblBuilds:
Builds_ID: unique id
Builds_subject: same as above
Builds_Scale: 1/48, 1/72, etc
Builds_Manufacture: same as above
Builds_Kit_Number: number to the kit (ex: 4345-0)
Builds_author: same as above
Builds_Magazine: links to the magazine ID
Builds_Image: same as above
tblHow_To:
How_To_ID: unique ID
How_To_Title: this can be an open text of article (ie: god i am lost on building a search function across all article tables)
How_To_subject: same as above
How_To_scale: same as above
How_To_manufacture: same as above
How_To_author: same as above
How_To_Magazine: links to the unique ID of the magazine
How_To_Image: same as above
-----------------------
Thanks for reading and taking the time
sean.
So say for example: you want to read all articles ( i am archiving 10 years worth of model building magazines, scanning the pages and hyperlinking them from local pc) pertaining to a p-51 (tblsubject) airplane in 1/48th (tblscale) scale from Revell (tblManufacture). I would like to search all articles and find all records that meet such criteria. I see examples of searching for data in one table but across many i cant find.. I tried to impliment an example with a queary that had all my tables in them.. what i got was a result with each table going sideways (make sense).
I am ok with having a result box for each article i guess.. but would REALLY love having them all in one list going vertical down. I may be asking for something impossible but would like to know if anyone has any idea how to go about that way. Now, FYI, other than being in each tbl there is nothing that says a certain article is a tblreview or tblbuilds (as in no field to mark the type of article it is).
I am still very new to VB and Access but not afraid to poke around and brake my test database.. so please keep that in mind..
Here is what each table looks like:
Here are my Constant tables that share the same data, each article table (tblreviews,tblinfo,tblbuilds,tblhowto) shares.
tblScale:
ID: unique ID
Scale: unique scale, no duplicates (ie: 1/48, 1/72 etc)
tblManufactures:
Manufacture_ID: unique ID
Manufacture: unique manufacture, no duplicates (ie: Revell, Tamaya etc)
tblSubject:
Subject_ID: unique ID
Subject: unique subject that will not duplicate (ie: p-51, p-38, etc)
-----------------------------------------------
tblMagazine:
Magazine_ID: unique id (this is how articles are linked to a magazine)
Magazine_Title: Name of magazine (linked from tblMagazine_Title)
Magazine_Month: Issue Month
Magazine_Year: Issue Year
Volume: Volume of magazine
Issue: Issue of Magazine
Cover_Image: hyperlink to a local image on pc
------------------------------------------------------------
Here are my Tables, These are the tables in need to search.
tblReviews:
Reviews_ID: unique id
Reviews_Subject: Subject of the article (ex: P-51, or P-38 etc)
Reviews_Scale: 1/48, 1/72
Reviews_KIt: number to kit, (ex: 46-545)
Reviews_Manufacture: tamaya, revell, etc..
Reviews_Magazine: this is what links the article to the tblMagazine unique ID
Reviews_Author: Author of article
Reviews_Image: hyperlink to local scanned image on pc
tblInfo:
Info_ID: Unique id
Info_subject: same as above
Info_Magazine: links to the magazine ID
Info_Author: same as above
Info_Image: same as above
tblBuilds:
Builds_ID: unique id
Builds_subject: same as above
Builds_Scale: 1/48, 1/72, etc
Builds_Manufacture: same as above
Builds_Kit_Number: number to the kit (ex: 4345-0)
Builds_author: same as above
Builds_Magazine: links to the magazine ID
Builds_Image: same as above
tblHow_To:
How_To_ID: unique ID
How_To_Title: this can be an open text of article (ie: god i am lost on building a search function across all article tables)
How_To_subject: same as above
How_To_scale: same as above
How_To_manufacture: same as above
How_To_author: same as above
How_To_Magazine: links to the unique ID of the magazine
How_To_Image: same as above
-----------------------
Thanks for reading and taking the time
sean.