Palm User Message Board 首頁 Palm User Message Board
give up phpBB! we must
 常見問題常見問題   搜尋搜尋   會員列表會員列表   會員群組會員群組 
 個人資料個人資料   登入檢查您的私人訊息登入檢查您的私人訊息   登入登入 

Need help on HanDBase skill

發表新主題   回覆主題    Palm User Message Board 首頁 -> PALM - 軟件開發 Printable version
上一篇主題 :: 下一篇主題  
發表人 內容

註冊時間: 2004-12-21
文章: 167

發表發表於: 2005-05-04 23:20    文章主題: Need help on HanDBase skill 引言回覆

First of all, please excuse me that I am not an IT professional. If you can help, kindly please elaborate a little more. Sweat Drop Million thanks. Wink

I have 2 databases, DB1 & DB2.
DB1 consists of field A, B, C, D
DB2 consists of field A, B, X, Y

When I am editing the last record of DB1, can I press something so that I can
1/ jump (create) to the new last record of DB2; with
2/ content of the last record of A & B in DB1 be copied to A & B in DB2

Please also let me know if there is no simple way to do so. Razz
檢視會員個人資料 發送私人訊息

註冊時間: 2004-08-27
文章: 42

發表發表於: 2005-05-07 0:56    文章主題: 引言回覆

Say you have a Mater table and a Detail table.

Fields in Mater Table:
- id
- description

Fields in Detail Table:
- id
- description

You want to have relationship between Master, Detail table as one-to-many.

In Master table, create one more field as follows:
- "Field Type" as "Relational"
- "Field Name" as "GoToDetail"
- "Other DB Name": "Detail"
- "Other Field Name": "id"

Now, when you are editiong Master table, just click on the field "GoToDetail", handbase will take you to the Detail table with the id same as the master table.

* I spent 2 min. to test the above in my Treo650, Comment/correction from expertises are welcome!
檢視會員個人資料 發送私人訊息

註冊時間: 2004-12-21
文章: 167

發表發表於: 2005-05-07 20:14    文章主題: 引言回覆

Hi tsangh, thank you for your reply.

My problem is I have 2 id's. In my example, I used "A" & "B".

The ideal solution is to find some way to simulate "two simple-joints between two tables" on PC database software.

Or, a technically independent question. Press something to copy two variables from one database to another.
檢視會員個人資料 發送私人訊息
發表新主題   回覆主題    Palm User Message Board 首頁 -> PALM - 軟件開發 所有的時間均為 台北時間 (GMT + 8 小時)

無法 在這個版面發表文章
無法 在這個版面回覆文章
無法 在這個版面編輯文章
無法 在這個版面刪除文章
無法 在這個版面進行投票

Powered by phpBB © 2001, 2005 phpBB Group
正體中文語系由 phpbb-tw 維護製作