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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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