Jump to content

Relationship for a Portal


malagasy
 Share

This topic is 5767 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi,

I'm creating a database at the moment and can't figure out something...pretty sure it is related to a relationship and value list problem.

My business is service oriented and we give the option to a customer to use our services during 1 or several weeks (max of 5 weeks). Each week has a different employee in charge of the customer and this information should be available for the customer.

For example:

W1, employee is John

W2, employee is David

W3, employee is Peter

I have created a table for this called WEEKS. 2 fields : weeks are in a Refweek field

employees are in a employees field

I have done a portal in order to add or delete records but I dont really know which relationship create so when I type W1, the name of employee will automatically appear next to it, so on and so forth.

What should I do ?

Thanks for your help

Edited by Guest
Link to comment
Share on other sites

This topic is 5767 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.