Table 1: Business
column 1: bus_id PK
column 2: busabbrev
column 3: busdesc
Table 2: Line
column 1: lob_id PK
column 2: lobabbrev
column 3: lobdesc
Table 3: State
column 1: st_id PK
column 2: stabbrev
Table 4: Products
column 1: prod_id PK
column 2: prodname
column 3: proddesc (memo)
Table 5: Measure
column 1: mea_id PK
column 2: meaname
column 3: meadesc (memo)
column 4: condition
column 5: meacd
column 6: submea
Table 6: Contact
column 1: contact_id PK
column 2: contact
column 3: phone
column 4: email
Table 7: Mem
column 1: mem_id PK
column 2: memfirst
column 3: memlast
column 4: memdob
column 5: memstr
column 6: memcty
column 7: memst
column 8: memzip
column 9: memphone
Table 8: DataTable
column 1: Data_ID PK
column 2: busabbrev (from above table)
column 3: lobabbrev (from above table)
column 4: stabbrev (from above table)
column 5: prodname (from above table)
column 6: meaname (from above table)
column 7: contact (from above table)
column 8: mem_id (from above table)
column 9: target
column 10: reached
column 11: converted
column 12: inputdate
column 13: timestamp
I am inquiring because I had the Datatable with just the ID's or the PK's from each table and nothing lined up right when querying. But when I used items from each table that we want to display on, it did work. and I actually join like stabbrev in datatable to stabbrev in state table.