primary and foreign keys

[billthecat]

I'm trying to be specific about what information is generated from the CSV export. I need three different versions of the same data (only certain fields for each). So if my users need their billing information for a certain date, they can navigate to the "Billing" table and run the search on that.

To do this, I've created two duplicate dbase tables (renamed appropriately) and linked them to the primary as a foreign key. The problem is that the link isn't producing any results - "(Total records: 0)".

Here's my setup:
Say my primary table is "records", 2nd table is "billing", 3rd table is "payable".

In my billing table on the recordid field I have set:

Field type: select_single
Primary key field: recordid
Primary key table: records
Linked fields: recordid

Shouldn't this display all the records in the record table?

I'm missing something really obvious here....I can feel it

 

[DebbieS]

Not entirely sure ... is this located somewher I can view it? Send a private email with subject of 'Dadabik review request' (so I don't delete as spam) with the URL if you do not wish to publicize.

 

[billthecat]

Thanks Debbie,

I've solved this by doing three dadabik installs then sharing the user table and sessions.