How to make Job Order Request

[smtazulislam]

Good Morning !
I would like to create a Job order Form and Job Order history Searcher.

Example : This order from Operation Manager
Operation department request a Job Order Like :

OrderDate	OrderUserName	DepartmentName	EmployeeID	EmployeeName	Country	CompanyName	City	Category	TransDate	TransLeave	Status
06/06/2023 06:30	Akram	Operation	1​	Abdulrahman Abdullah	Saudi Arab	UPS	Riyadh	Audit	01/06/2023		Current
06/06/2023 06:30	Akram	Operation	3​	Eman Awadh	Saudi Arab	FedEx	Jeddah	Driver	01/06/2023		Current
06/06/2023 06:31	Akram	Operation	5​	Abdullah Abdul	Saudi Arab	UPS	Madina	Production	03/06/2023		Current
			​

These Employee Replacement & previous workplace details :

OrderDate	OrderUserName	DepartmentName	EmployeeID	EmployeeName	Country	CompanyName	City	Category	TransDate	TransLeave	Status
06/06/2023 06:30	Akram	Operation	12​	Abdullah	Saudi Arab	ANB	Abha	Audit	02/07/2022		Current
06/06/2023 06:30	Akram	Operation	8​	Awadh	Saudi Arab	Saggaf	Jizan	Driver	15/01/2022		Current
06/06/2023 06:31	Akram	Operation	2​	Abdul	Saudi Arab	UPS	Makkah	Cleaner	01/06/2023		Current
			​

This message need to transfer in HR manager Desk ? When HR manager has been approved then Operation Manager will print.

How can I do it ?
Any help will appreciate...

 

[June7]

What is stopping you?

You show order date/time but no order number. Why do these orders show different EmployeeIDs in the two data samples?

"This message need to transfer in HR manager Desk ? When HR manager has been approved then Operation Manager will print."
This line makes no sense.

 

[plog]

95% of forms are actually pretty straightforward...once you have the correct table structure.

I would like to create a Job order Form and Job Order history Searcher.

Sounds like the job order form should be based on your Job Order table and the Job Order History Searcher should be based on a query that combines all the datasources you need to get the fields you want to display/search with a bunch of unbound inputs at the top to select the criteria for the search.

This message need to transfer in HR manager Desk ? When HR manager has been approved then Operation Manager will print.

The first time you use the term 'message' is in the above sentence which makes the 'this' very confusing. You can't use a completely new term like it's one we are familiar with. Further, this gets back to my initial statement of having the correct table structure. Whatever is involved with 'transferring a message' sounds like a data issue and not a form issue. Perhaps you can post a copy of yoru database or at least a screenshot of your Relationship Tool.

 

[smtazulislam]

What is stopping you?

You show order date/time but no order number. Why do these orders show different EmployeeIDs in the two data samples?

I had make it two table. JobOrder and JobOrderdetails. By mistake to remove Job Order Numbers

"This message need to transfer in HR manager Desk ? When HR manager has been approved then Operation Manager will print."
This line makes no sense.

Operation Manager request for some NEW worker give to him for replacement
or
Operation Manager request for some worker change placement .

If HR manager has approve the list of the messaged then Operation Manager can print out. Before he can't print out, because the print button is disabled.

Sample db attached, I try to give you a example what I need.
I need also a form for HR manager will see the request and approve.

 

[smtazulislam]

95% of forms are actually pretty straightforward...once you have the correct table structure.

I agreed, Actually I have no idea how to easily to design the table for this transaction.

Sounds like the job order form should be based on your Job Order table and the Job Order History Searcher should be based on a query that combines all the datasources you need to get the fields you want to display/search with a bunch of unbound inputs at the top to select the criteria for the search.

The first time you use the term 'message' is in the above sentence which makes the 'this' very confusing. You can't use a completely new term like it's one we are familiar with. Further, this gets back to my initial statement of having the correct table structure. Whatever is involved with 'transferring a message' sounds like a data issue and not a form issue. Perhaps you can post a copy of yoru database or at least a screenshot of your Relationship Tool.

Post # 4 is my sample db. I try to show you What I need. I knew my table need redesign field relationship. Need some help to redesign my table.

 

[mike60smart]

I agreed, Actually I have no idea how to easily to design the table for this transaction.

Post # 4 is my sample db. I try to show you What I need. I knew my table need redesign field relationship. Need some help to redesign my table.

Hi
Your JobOrderDetails table makes no sense whatsoever.

Normally a Job has a number of Details related with it.
In your case all you are selecting for the Job Details is Employee, Designation and other fields that do not relate to Order Details??

Also your relationships between Employee , Designation & Department have no Referential Integrity applied.
This means you can add Child Records without there being a Parent Record.
The attached shows the error when you try to Enforce Referencial Integrity between these tables.

 

[jdraw]

I suggest you describe your "business" in simple, pain English. Create a list of "business rules".
Create a data model based on your business rules. In your design, establish referential integrity on your relationships to have the database system help you.
Take some sample data and scenarios and test them against your model.

 

[smtazulislam]

My apologies, May I explain yous.
I dont try to make a purchase order database.

Work Details :
I tried to create a Recruitment Database.
We have 5 departments in this company and 42 projects. Sometimes we need to deployed new workers in various projects whose has joint recently. Sometimes older worker need to replace one place to another place.

We added any project TWO WAYs.
1) Without replacement.
2) Replacement

1) Without replacement means. : We have before 5 and now added some one new.
2) Replacement means. We have before 5 quantity and now we replace some workers and same quantity 5 given replacement.

Database Work:
Each department manager been request by JOBORDER to HR Manager by form. Then HR manager will approve. And record should time stamped.

Can some arrange to redesign the table format ?

Edit :/ All of them should be inquiry by EmployeeID Numbers.

 

[smtazulislam]

You show order date/time but no order number. Why do these orders show different EmployeeIDs in the two data samples?

I had update with JOBORDERID in post 8. Later I will re-format JOBORDER numbers by sequential

"This message need to transfer in HR manager Desk ? When HR manager has been approved then Operation Manager will print."
This line makes no sense.

This database use each department manager.
Manager request JOB Order to HR manager. then HR manager finds notification that someone order to him. He will approve.

 

[smtazulislam]

Hi
Your JobOrderDetails table makes no sense whatsoever.

Normally a Job has a number of Details related with it.
In your case all you are selecting for the Job Details is Employee, Designation and other fields that do not relate to Order Details??

No, New job order is not relate with Order details.
But when replacement can related.

Also your relationships between Employee , Designation & Department have no Referential Integrity applied.
This means you can add Child Records without there being a Parent Record.
The attached shows the error when you try to Enforce Referencial Integrity between these tables.

Kindly check with post #8

 

[mike60smart]

Hi
Again logic would say that if you want to add personnel to a specific Project you would need to first Select the Project
to add the personnel to.

Likewise, if you want to change a specific Employee for a different one.

 

[smtazulislam]

Hi
Again logic would say that if you want to add personnel to a specific Project you would need to first Select the Project
to add the personnel to.

Likewise, if you want to change a specific Employee for a different one.

Noted.

 

[smtazulislam]

Now, I facing some problems with records.

frmJobOrder - in sfrmJobOrderDetails
if I enter data in the subform, then the Next data will autofill without EmployeeID. I Just Enter the EmployeeID the Others fields have been autofill

frmJobOrder - sfrmJobOrderReplanceDetails
if I enter the EmployeeID then DLOOKUP the latest previous data and saved it in the table OUT.

How can I do it?


Db uploaded.

 

[smtazulislam]

Any help ?

 

[mike60smart]

Any help ?

Hi Would it nor be easier to just Duplicate the last record in the subform and then just change the Date and the EmployeeID