Help...I'm a new User

[Annette Marie]

Ok...I apologize in advance if I'm asking stupid questions or making silly mistakes, I'm new to FM and pretty new to creating databases.

I am trying to create a database the has the following info:

Client name - first, last

Client ID

Priority level

Service provider

Services

dates and times they attended the specified service etc

Basically what I was thinking was making it like the time cards starter database with some elaboration maybe.

I have the following tables:

Users

Providers

Services

UserServ - Users/services

UserProv - Users/Providers

Am I on the right track do you think?

What I wanted to do was have one form where you enter new users. And a form similar to time cards where you enter a date, the time they arrived and left, what service they availed of (in a drop down menu), a radio button if they stayed overnight, a radio button if that particular scheduled service date was cancelled.

I think it's relationships that are confusing me as well.

Any help or suggestions would be appreciated.

[comment]

what service they availed of

Could there be more than one? If yes, could they be provided by different providers?

[Annette Marie]

Well they could have more than one service....but I was thinking of doing it like time cards...so each line item would only be for one particular service. But you could have several lines on each card, each line may be a different service.

Each provider I would like to have their own login so that they only see clients that attend them and not clients that attend other providers. But....clients could attend more than one provider at different times.

So if I have

Client 1 who sees provider 1

Client 2 who sees provider 2

Client 3 who sees provider 1 & 2

I would like provider 1 to be able to bring up client 1 and 3 and provider 2 to be able to bring up client 2 and 3.

Does that make sense?

[comment]

If they could have more than one service, then you need a table for the line items. This seems very similar to an invoicing solution - see a basic demo here:

http://fmforums.com/forum/showpost.php?post/309136/

In your case, you need another table for the providers. This would be linked either to LineItems or Services - depending on whether services are provider-specific or if any provider can provide any service.