consecutive alphabet letters in composite ID field

[focosi]

I have 1 form for recipients and 1 form for donors, linked via ID. Donors have "Donor ID" as primary key : this field is "ID-progressive alphabet letter" (i.e. recipient 415 has donors 415-A, 415-B, 415-C, etc...) How can I autofill the "Donor ID" field with progressive alphabet letters once a new donor record is created for a given recipient ???
I think I have to use the recordset to find how many records have been associated , but can't figure out why ?

[June7]

You want to construct a unique ID. This requires VBA. Common topic. Search forum and Google. Here is a start:
https://www.accessforums.net/showthr...=custom+unique

[orange]

Further to june7's comment, you may be trying to hard to put meaning into a code. Why do you need that particular scheme? If it's for human use you could have such a field, but also have an autonumber PK for Access to use. With RDBMS one fact, one field is often the simplest and easiest method.

In general terms you are dealing with

Donors and Recipients, which could be a many to many relationship. You may just be missing a junction table - DonorReceiver or any name you choose, that relates a Donor to a Recipient on a certain Date.

DonorReceiver would have the following fields

-DonorReceiverId PK (autonumber)
-DonorId FK (Donor table)*
-RecipientId FK (recipient table)*
-DonationDate dateTime*
- any other fields specific to this Donation

* NOTE These 3 fields would be used to create a unique index to prevent duplicates.