I am a bit stuck with this one, and not well versed in scripting / coding. Though I think it should be fairly simple to do?
I have two tables :
A - A range of dates spanning a month or so. Dates are always consecutive, so 12th May, 13th May, 14th May etc
B - A list of people with a field for start date, and a field for end date (this is manipulated using a Timeline view and works well),
I’m trying to write a script that updates a linked record from Table B to Table A for each start date, end date and every date in between. This is used to work out when someone needs a hotel room booking.
Table A - 1st May to 30th May - 30 records
Joe Bloggs - Start 10th May, End 14th May
Bert Reynolds - Start 14th May, end 20th May
I’d have a field in Table A called “Accommodation” which links to Joe Bloggs in Table B on the records for 10th, 11th, 12th and 13th May
Also in Table A, the accommodation field would have a link to Bert in Table B for records from 14th May to 20th May
Table A would then be a really useful Master accommodation list for the project (amongst other things)
May seem odd, but I’d have another table with a lot of detail for things that happen on each day.
Hope that makes sense? Any ideas well received