Jump to content
Sign in to follow this  
Ken Ball

Date function

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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:

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.