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.

"... 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.

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.

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

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.