Date function

[Ken Ball]

I have 2 data sets - customers and line item.

The customer field has dates - start date and end date for the interaction.

There is generally one to four items purchased per day.

The invoices are generated at the end date of the interaction.

I want to enter the customer data with start and end dates and have the portal to line item populated with dates so that each purchase can have a date associated with it.

is this possible?

[bcooney]

This sounds like an unusual data model, and makes me think there's info missing.

Customers don't have line items, invoices do.

Why would a customer have a start date and end date? ..for an interaction?

You're creating line items and then the parent invoice?

[LaRetta]

Hi Kenny, welcome to FM Forums!

customer data with start and end dates and have the portal to line item populated with dates so that each purchase can have a date associated with it.

In addition to Barbara's points, in a proper relationship, there wouldn't need to be the same dates in both tables because the customer's primary key (placed in the LineItems table) would allow the dates to display or flow through to LineItems as needed. You are using Primary Keys, right?

If you can describe your purpose and existing setup, we might have clearer vision to assist you.

LaRetta :wink2: