Jump to content
Sign in to follow this  
Greg Hains

Spreadsheet type data entry.

Recommended Posts

Hi.

I have two tables. One is "Job List" which is a list of jobs for clients, and the second is "Timesheets" which is used for employees to enter times against various jobs in the first database.

The layout Im using (in Timesheets) allows users to enter a single timesheet entry at a time against a single Job List job.

I want to have it so I have a spreadsheet layout (assumably a portal) that allows me to enter multiple tasks for an employee on any of the jobs inthe first table. I can sort of get this working, but am having trouble with a feature the client requires.

In the timesheet entry screen I can drop down a lookup list to the list of job numbers, but the client needs the ability to add entries to the timesheet based on a client name. Say that they dont know the actual job number but want to find it from the client name. As there may be several jobs for the same client, Im looking at doing a constrain. Problem is that this itself is "straining" my brain working out how to achieve it.

I guess in short if I can bring up a list of each job number with the client and job description, click on that row and have it enter that job number directly into the timesheet field.

Does this make sense or have I over explained/complicated it?

Greg

Share this post


Link to post
Share on other sites

Ok. Ive thought of a way to simplify my requirement.

I have a layout using the Timesheet table. I want to select the contents of one field (job number) from the Job List table. However, I need to be able to display the full list of jobs from the Job List table. When I use a portal it doesnt seem to work.

How can I display a "portal" to all records in the Job List table that I can pull a job number from and "bring it back" to the layout with timesheets.

Maybe Ive complicated it even further? lol

Greg

Share this post


Link to post
Share on other sites

Ticket Closed. I have worked it out.

Im not being funny or sarcastic when I say thanks for this forum. It has been of enormous support to me in my early FmPro days.

Cheers,

Greg

Share this post


Link to post
Share on other sites

Hi.

I THOUGHT I'd worked it out - all I did was balls up my database. :

Anybody know of a way where I can have several users simultaneously updating a timesheet database whereby they have a spreadsheet type layout?

Greg The Desperate.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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