Search results

The attached is the Relationship Window and there are no Relationships set.

This is a 6 year old thread ??

Hi I agree with everything that Plog said. Your current FarmerT should not contain the following fields and should only contain field that describe the Farmer:- MISSystem DealerName EmplyeeName TotalMISCost

Hi Your FarmerT should be named CustomerT to avoid the confusion you have caused with your question regarding Customers. Why would you want to copy the details of the Farmer to the DespatchDetailsT ? You are selecting the Farmername using a Combobox so that identifies the Farmer by storing the...

Hi Does the Report now give you the correct result?

Which Report are you referring to and what data are you expecting to be displayed. First look at you relationship diagram shows that there are no relationships set between any of your tables. You are trying to retrieve data from Investments01_tbl and Investments_Puchases_SalesT where you have...

Hi You can download the Google Docs file into Word and then zip the Word file and post the zip file.

Hi Al It looks like you do not want to take good advice. If I were you I would re-read all posts again to see where you are going wrong.

Hi Al Are you able to upload a copy of your database with no confidential data?

Hi Al Why not just do the Merge into an Access Report?

Hi Are you trying to add New Referral details for the Patient Details obtained via your Search Form ?

Take a look at your exact same question on AccessForums. I have given you the correct method of solving your problem.

From your screenshot it looks like you have created a database for each table. All of your tables should be in one database.

Sorry but your explanation makes no sense to me at all.

The AuthorizationEditF Form opens. Do you want the unbound Controls which display as Grey Colour to be enabled to Edit??

What is the name of the Form that you have the problem with?

I think a more detailed description of your process is required. Does 1 Customer have 1 or more Projects and each project can have 1 or more Job Sites?

Glad to help

Hi My apologies but I missed the fact that you want all items to be added in the order that they were in your tblChecklistDetails. I have modified the process so that now you just click on the Command Button "Add All Items" Does this suit?

Hi There will probably be a better way of doing this but this is one way of doing what you want. On the Form that opens when you use the "Trade" Combobox and select a Trade, then all related Items will be inserted into the Subform.