Date Field

[jeffEngland]

I have a date field where the user selects a specific date. When the user selects that date I would like to have a record created. However if the user selects the same date again on another record I do not want another record created with the same date.

I am new with filemaker and am unsure of how to go about solving this problem. If someone could help it would be great

Jeff

[aldipalo]

Here's one way you can do it. (See attached file.)

Date_Test.zip

[jeffEngland]

Thx for the help but,

I may have been a little vague in my description. The user inputing information into the database can choose any date they wish, not just the current date. If they choose the same date twice I want it to add data to the newly created date record instead of creating a new record.

Jeff

Edited May 23, 2006 by Guest

[comment]

It's still a bit vague, but see if the attached gives you an idea.

AutoCreate.fp7.zip

[jeffEngland]

Sorry for being vague I was trying to simplify my problem so it would be easier to respond too.

here is my problem. I have a customers table where customer I enter customer information, I also have a Invoice table and line Items table for customer purchases which all work fine. I can have many customer on a particular date.

However I need to seat my customers. I am currently creating a new record in my seating table when I select a date for when my customer will be attending. However thats the problem if I have more than one customer on a particular date more than one record is created in my Lanes table. I only want one record created for a particualr date. Inside that record I need to show all my customers attending that day, how many seats they are using amongst other things. That information will be shown using a portal.

I cannot use a portal to sort my date either.

If anyone could point me in the right direction it would be appreciated

thx

Jeff

[aldipalo]

Forget the attachment I misread your response.

**********************************

And why can't you have a list layout for the day that shows their seat number and date of meeting?

Date_Test.zip

Edited May 24, 2006 by Guest

[jeffEngland]

Found my answer by way of another topic. Thx for the help

Jeff