ChristianEhlers
New member
- Local time
- Today, 15:55
- Joined
- Jan 6, 2022
- Messages
- 8
Good evening,
at fist please excuse my english as I am not a nativ speaker. I do not know all the right IT expressions.
My problem:
I did create an incoming process with Access. In this I do have a main table (TIncomingHead) and a main form (FIncomingHead) with several data (like supplier, date, ...). The main table does have an primary key "WEKennz1".
For the incoming details I do have a sub table (TIncomingDetail) and a sub form (FIncomingDetail) with data for each incoming line item. This table has another primary key.
Both forms are connected via the key"WEKennz1"
Sometimes I need to cancel receivings. To do this I do have a field "Storno" in the table (TIncomingDetail) as I do not wish to delete the data sets.
Sometimes I need to cancel not only line items but the complete receiving with all line items of one "WEKennz1"
I would like to do this directly from the main form with a mouse klick on a button called "DeleteAll"
Unfortunately I do not know how to select all line items with the current WEKennz1 and set the "Storno" field to yes.
Any ideas and help would be greatly appreciated.
Thank you very much and best regards
Christian
at fist please excuse my english as I am not a nativ speaker. I do not know all the right IT expressions.
My problem:
I did create an incoming process with Access. In this I do have a main table (TIncomingHead) and a main form (FIncomingHead) with several data (like supplier, date, ...). The main table does have an primary key "WEKennz1".
For the incoming details I do have a sub table (TIncomingDetail) and a sub form (FIncomingDetail) with data for each incoming line item. This table has another primary key.
Both forms are connected via the key"WEKennz1"
Sometimes I need to cancel receivings. To do this I do have a field "Storno" in the table (TIncomingDetail) as I do not wish to delete the data sets.
Sometimes I need to cancel not only line items but the complete receiving with all line items of one "WEKennz1"
I would like to do this directly from the main form with a mouse klick on a button called "DeleteAll"
Unfortunately I do not know how to select all line items with the current WEKennz1 and set the "Storno" field to yes.
Any ideas and help would be greatly appreciated.
Thank you very much and best regards
Christian