Merging two tables

[papasmurfuo9]

Hi

is the following possible, thanks in advance ;

So i have two tables

Table one list of names

Table two list of tasks

I want one table to have the list of names, then record in the table is expandable with a list of tasks


So Table 1

Michael
Roger
Tim

Table 2 :
Headers: Tasks | Date Completed
Task 1
Task 2
Task 3

then a new Table

Then if i expand Michael its

Michael
Tasks Date Completed
Task 1
Task 2
Task 3
Roger
Tim

but when expanding Michael, the date completed entry - is kept unique to michael and not duplicated among the other records!

thanks

 

[isladogs]

Hi

Not sure if you want to merge tables or show the linked records in each

If you really want to merge them, then I would ask why?

If its just the latter, you can do this in several ways e.g.:
1. Use a query linking both tables
2. Create a form with table 1 & a linked subform with records from table 2
3. Use subdatasheets when looking at the tables.
See https://support.office.com/en-gb/article/Add-a-subdatasheet-900d1d30-5ea2-4e47-80a7-ddcb87a53d14

 

[papasmurfuo9]

thank you kind sir