Parameter box keeps popping up

[joeythelips]

Hello,

I have 2 tables in my database: reference and billing.
I want to join these tables using refid from reference as the primary key joining refid in the billing table.
I am using the TransferSpreadsheet method to populate the billings table and an sql insert statement to populate the reference table.
I want to have primary key reference.refid as an autonumber datatype.
However, when i run a query, the join doesn't seem to work, even though there is data in both tables.
Has anyone any ideas?

Joe

 

[Tmconsult]

Your question post say a parameter box keeps popping up, what field or expression is it asking you for?

 

[Guest_imported]

the parameter box that keeps popping up asks for referenceid

 

[tlbroadbent]

You must have a referenceid set as a column name or criteria in your query. From your desription it should be refid, instead. If that doesn't seem to be the problem, please post the query so we can help debug it. It will also help if you post sample data from both tables - just a few records. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.