Trouble with ToDo's

[yilbber]

I' Need the ability to Match Multipe ids from a repeating field to another table.

Would Making that table's matching field repeatable work?

The intent is that if I go to the calendar, where each user is listed, filter for person x, He will appear despite not being the primary ID on a show

or do I need to Add a new Join table, Add the Extra  users, and Cross Relate it where ever that "staff id" is.

such pk-id_crew, Staff ID, and match staff id to the Primary Key table where staff is called up? (for example, the Staff and project PK's)

 

Currently the Calendar is ignoring the other people in my table.

 

 

[Matthew F]

I don't quite get what you mean by "filter for person X" on the calendar.  I would think a Calendar is table of dates or events. 

 

To answer your question, you can use a repeating field to set up a many-to-one relationship between two tables.  However, it sounds like you may be trying to build a many-to-many relationship, and in this case you will need a join table. 

[bcooney]

is this an issue with FM Starting Point and how it is designed to work?

[yilbber]

I think the biggest problem with FMSP is that there are no Relations almost anywhere between various fields, or at least, only the account fields behave the way it should it does NOt like having to deal with client/venue/Manager relationships. (where a X Client may use Y location, X location may have it's own number, and person B needs to talk to Event leader

It's done entirely almost by scripted actions which make things unbelievably complicated.

 

I believe it is ok for a normal inventory based business, but totally unsuitable for service based business.

[Lee Smith]

Automatic message

This topic has been moved from "Managing Scripts" to "FM Starting Point - General Discussions".

[Richard Carlton]

It can work fine for a services based business... especially with the upgrades in 4.3.   However... it seems that you have specific needs... so you will need to treat it like a "Starting Point" and add the items to it... that will make it fit well to your business.

 

- Richard