HelloI have two tables. When creating a meal date, you can use the ls_order_lunch field in the table name: lunch_setup to filter out people who have not eaten, and write the values of fields 2-6 into the table name: Lunch table 3-7 fields.The first table name is: lunch_setup
Purpose: Mainly to record information about employee ordering meals.
- Serial number (ls_id)
- Employee number (ls_id)
- Whether to order (ls_order_lunch)
- Meat or Vegetarian (ls_mav)
- Quantity of soup (ls_soup)
- Bento placement position (ls_position)
Another table named: lunch
Purpose: Mainly to record which day there is a meal.
field is
- Serial number (l_no)
- Subscriber (ls_id) ※ lunch_setup corresponds to employee number (ls_id).
- Order date (l_order_date)
- Meat or vegetarian (l_mav) ※ lunch_setup echoes meat or vegetarian (ls_mav).
- Soup quantity (l_soup) ※ lunch_setup corresponds to soup quantity (ls_soup).
- Lunch quantity (l_quantity) ※ lunch_setup echoes whether to order meal (ls_order_lunch).
- Lunch placement position (l_position) ※ lunch_setup corresponds to lunch placement position (ls_position).
The final result will be to add records in batches through meal dates, and write the list of people who have meals into the Lunch table.Thanks for help.Ancen