Help with a calculated table field

I think I also answered your second question but just in case... You will probably have to, in the queries, remove Donar Name and put in your query and link via the iD field. Once you have done that to all the queries you are using you can check your Forms. If all is okay remove from Donation table.
 
In creating a field to replace DonorName, I used a lookup wizard for "FileAs Query". It asked me if I want to store multiple values for this lookup. Not sure what that meant but I went ahead and said yes. Seems to have worked but not sure if I made the right choice.

Sorry I've really slowed down on this...family issues getting in the way. Hard to think clearly.
 
No problem, I had a busy day myself... I never used the Lookup Wizard so I can't say what you did. Did you do this at the Table Level?
 
Hmm, I got a message that something was posted but now I see nothing. Did you delete a post?
 
Yes, I had posted a question that I immediately found the answer for.

But I've really been struggling with the relationships now. Trying to create the one-to-many relationship from the Donor to Donations field. I assume it would be Donor/ID to Donations/FileAsID. But I'm getting the error "Relationship must be on the same number of fields with the same data types."

DonorID is an AutoNumber. FileAsID is Text and comes from the FileAsQuery you helped me create.

I have SUCH a headache trying to figure this out. I honestly think I ought to go back to my original db--I've spent much more time trying to adjust than I would have spent creating my own. You wouldn't kill me would you, if I start over from scratch and then ask help as I go along? :(
 
You cannot create a relationship between numberic values and text values, only text to text or number to number.

If you want to start with origianl file I would not be upset. You need to do what works best for you. I here to help no matter which file you want to amend.
 
Before I return to my original database, HOW would you create a relationship between a Donor table and a Donations table? Each donor has an AutoNumber ID. There's an AutoNumber ID for each donation too, but obviously one donor can have many donations. Where/how to join?
 
Place a DonorID in the Donations table and create your Relationship that way.
 
And what do I put in that field? Should it be a lookup query based on Donor ID from the Donors table?
 
You just add it to the Donations table then on your Form you can create a Combo Box looking you the Donors. Do not use the Look-Up via the Table level to much confusion doing it that way.
 
So those two fields I added: "FileAsID" and "AddressAsID"--I didn't need to make them look-up either? I can just do that in the forms? Will go experiment...
 
So...referring back to somewhere around post 39 where I created those two queries to produce FileAs (Smith, John) and AddressAs (Mr. and Mrs. John Smith)--do I even want to have those fields in my donors table? That's where I put them with a lookup query. But can I simply leave them out of the table and introduce the two queries elsewhere to achieve the result I want in forms or reports?
 
That is correct, not in Donors table but on their own to be used everywhere.
 
I composed a rather complicated post last night--and then we lost our Internet connection and it went poof. Argh. So here it is again:

:eek: Oh no! I had re-written it in a draft email--and now that draft is gone too!

:banghead:

If I were being paid to do this, it would be one thing, but this is getting to be too much. (No, not really; I'm just feeling sorry for myself right now.)

ANYWAY, let me try to compose this question again:

Here are my two tables and their relevant fields:

Donors table
ID (Autonumber)
LastName
FirstName
Title
FileAs (calculated: [LastName] & ", " & (" "+[FirstName])
AddressAs (calculated: [Title] & (" "+[FirstName]) & (" "+[LastName])
Greeting (calculated: [Title] & (" "+[LastName])
etc

Donations table
ID (autonumber)
DonorID (number)
CampaignID (number)
DonationDate
Amount
PaymentType
MatchingContribution

Now the Donations table is where I deleted the calculated fields "FileAsID" and "AddressAsID" since you said they were better off as separate queries. (I left them in the Donors table because I couldn't see how else to create the queries without basing them the table info. Was that correct?)

But then I couldn't join the Donors and Donations table without a number field to join them so I created DonorID--which you said I should leave empty.

But how do I think make that connection between the two tables that will give me the donor's name with each of his/her donations? I have no other field called DonorID in any other table. And my queries that had previously come up with donations and donors are now coming up blank.

I said this all much more clearly last night, but once again I've lost my train of thought. See my other thread for a question about this whole project...
 
I don't know if this thread should be deleted or not--I gave up on trying to make that template fit for what I was doing and started over with my own database. It came together much faster and does just what I want.

Have no idea why this thread got so many stars for being of interest...
 
You must log in or register to reply here.

Similar threads

A
Solved Problem creating greeting for a letter(access report)
Replies
17
Views
343
Al Kramer
A
D
Solved Nesting IIF Statement with functions that end in (field)
Replies
13
Views
366
arnelgp
arnelgp
D
Need help with SQL in an Access query that has UNION for the non-relational queries/tables
2
Replies
26
Views
1,083
dlhappy
D
D
Solved Unbound form required using VBA
Replies
9
Views
685
Pat Hartman
P
J
Convert multiple records into a single record
Replies
5
Views
684
JudyR
J

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom