Concatenated Fields relate to concatenated fields.

[allanc]

Hi,

I'm new to FMP development. Please excuse me if i have been overlooking something.

I have 2 database. First is Employee database with EmployeeID as key and another is Attendance database which contain fields EmployeeID, LogDate, LogTime, and others. I have created a field IDMonthYear (Text) in Attendance db which is set to 'EmployeeID & MonthName(LogDate) & Year(LogDate)' (text) thru a script.

On the other hand, i created a field IDMonthYear in Employee db which is set to 'EmployeeID & Month & Year' (text) where Month and Year fields are set thru pop-up list.

My objective is to relate the 2 db and create a portal inside Employee db which displays data per month and year (of each employee record) depending on user's choice.

I can seem to make the right data appear in the portal. Any help will be appreciated.

[Vaughan]

"... I have created a field IDMonthYear (Text) in Attendance db which is set to 'EmployeeID & MonthName(LogDate) & Year(LogDate)' (text) thru a script."

A calculated field would be better for this.

[allanc]

Hi Vaughan,

"A calculated field would be better for this."

I am apprehensive to make IDMonthYear field into a calculated field since i expect the Attendance db to grow in records rapidly (at least 5000 new records a day). I'm afraid effeciency of db will be affected. But anyway, i've tried it and i'm still having problem showing the right data in my portal.

[Wendy T]

hi Allan

Firstly, check the obvious. Are all fields in the portal using the same relationship as the portal itself?

Secondly, perhaps the year and/or month is slightly different on each side of the relationship, which would result in no records showing. For example, a 2-digit year vs a 4-digit year.

Thirdly, in the Employee db, make sure both Month and Year are globals otherwise the month & year set by the user will only be valid for the current record.

hope that helps.

cheers,

Wendy

[allanc]

Hi Wendy,

Thank you very much. I think i was standing too near to the tree. I have named the relationship almost the same as other relationship i have used (Attendance, Attendance 2) and i have some fields in the portal using a different relationship as the portal itself.

Guys, thanks again for all the time replying to my post.