I am such a novice at this, I hope I can accurately explain the problem.
My goal for this to combine the sales and listing data from online source with my product data that I need to help me understand what is working and what designs I need to focus more on.
Within a single Base, I have 2 tables with 2 sets of Data that are not currently linked. I will call them TABLE A & TABLE B.
TABLE A - contains rows of listings for online products. Each row contains a single product with various details about the listing. This data is updated from an external source of my online vendor.
For Example, A1 Title / A2 Listing Copy / A3 Number of Sales / A4 Product type / A5 UPC / etc…
TABLE B - Contains my information about the online product. This is info and categories that I have created to help me track my designs and organize them for my use.
For Example, B1 Design File Number / B2 Niche / B3 Thumbnail Image / B4 Ad Campaigns… etc
I understand that I can link individual fields from one table to another through record linking. Still, I want to be able to link all the fields in a row from one Table to another where all the data comes over in their rows without having to link each individual field per row.
So that I can point to the corresponding row once per row.
Giving me a table that is:
A1 / A2 / A3 / A4 / A5 / B1 / B2 / B3 etc.
How do I get all of the data from Table B to populate into the corresponding row on Table A. I am assuming that I need to point at least one of the fields from Table B to its corresponding Row in Table A.
I am sure I am just missing something simple here.
Thanks
Jim