Microsoft Access? Try Microsoft Barrier.
May 7, 2014 8:19 AM Subscribe
Oh, kind people of Metafilter. Please help this Microsoft Access newbie figure out how to connect different tables together when there is no predefined relationship. *Snowflakes inside*
posted by oceano to Computers & Internet (7 answers total) 2 users marked this as a favorite
The goal of this project is for users to be able to compare the "#" and "description" of column A with the "#" and "description" of column B. Each number is unique. The “# and DescriptionA” are two separate columns found in Tbl_I, and the “# and DescriptionB” are two separate columns in Tbl_II. It is likely that users will want to change the numbers in both columns A and B at various times since the relationship between the two columns is not predefined.
Example table is below:
GROUPING _| A (MAMMALS)_____|B (REPTILES) ______| OLD_RATING | NEW_RATING
(TYPE IN)___|#-> DESCRIPTIONA | #-> DESCRIPTIONB_|(1-3)______ | (1-3)
HAS 4 LEGS_|M01. CAT_________ |R06. FROG ________| 3_________| 3
A GOOD PET_|M03. DOG________ |R05. ALLIGATOR ___| 1 _________| 3
The user may want to change “R05. Alligator” in Column B to “R04. Lizard.”
Potentially complicating factor#1: “DescriptionA” and “DescriptionB” are greater than 255 characters, and splitting their contents into multiple columns is not an option. Because DescriptionA and DescriptionB have up to ~600 characters, I think it would be easier for users to select the number from a drop down menu, which then “pulls” the data for the relevant description.
Potentially complicating factor #2: Eventually I need to link “M01. Cat” to Tbl_3 which has data in the following columns: Kingdom, Phylum, Class, Order, Family, Genus, Species, Encyclopedia Article. The Encyclopedia Article definitely has more than 255 characters.
Potentially complicating factor #3: Ideally, this can be exported into excel.
I'm using Microsoft Access 2010 on Windows 7.
I would greatly appreciate any suggestions on how to do this, or even keywords to Google.