automation to link child record when parent record is created after
I need some help with trying to find a solution. In my program I have an Expense Table where all purchases with company cards.
Now I'm going to make another table for credit card bills, and relate the tables. [Credit Card Bills] is parent to [Expenses]. Since the billing dates vary a little month to month it would need correcting each month. Also, expenses are created before the bills(because it comes at the end of the month).
So what I would like to do is in The [Credit Card Bills] Table create a new record stating, billing start and end date and credit card number. Then have some kind of automation that links expenses from [Expenses] table where its transaction date is between the [Credit Card Bills] start and end date and matches the card number.
Is this possible?
------------------------------
Russell Beaubien
------------------------------
Now I'm going to make another table for credit card bills, and relate the tables. [Credit Card Bills] is parent to [Expenses]. Since the billing dates vary a little month to month it would need correcting each month. Also, expenses are created before the bills(because it comes at the end of the month).
So what I would like to do is in The [Credit Card Bills] Table create a new record stating, billing start and end date and credit card number. Then have some kind of automation that links expenses from [Expenses] table where its transaction date is between the [Credit Card Bills] start and end date and matches the card number.
Is this possible?
------------------------------
Russell Beaubien
------------------------------
