Conditional Relationship between specific Fields on two Seperate Tables

[KiowaPilot]

Looking for help on how to have specific fields on Table A update into Table B in a 1 to Many relationship



I need "Date of Sale" from Table A to update "Date of Sale" on Table B so that only most recent sale shows on Table B while also updating either "Cash" or "Credit" fields in Table B depending on which was used also only showing most recent sale.

[orange]

??Please describe the "business" being supported by this proposed database.

In many situations a Sale occurs on a specific date. I'm not sure how to interpret

the most recent Sale

. Is it the Sale of Product X to Customer Y? This can be done via a query.

Perhaps a little more detail and an example or two would clarify your post and requirement.
It would also be helpful if you posted a jpg of your tables and relationships.

[KiowaPilot]

Each sale, entered into our sales table (Table A) in batches of roughly 200 at a time, will be for a specific customer already in our customer table (Table B).
Trying to track most recent date of sale for each customer and when was the last cash or credit purchase.
I want my customer table to be updated each time I append data onto my sales table.

[orange]

I recommend you use a query and not duplicate data.
I also suggest you use a naming convention that does not have embedded spaces in field/object names.